I am working with 4 columns across two sheets.
Sheet_1 contains a column of text and a corresponding column of values.
Sheet_2 contains a column of text, some of which can be matched to the text column in sheet_1 and some cannot; all rows of cells in sheet_1 text column should match a cell row of text in the sheet_2 text column, but not vice versa because sheet_2 text column contains additional text rows.
The fourth column is a blank column in sheet_2 where I want to return the value of the second column in sheet_1.
The text column in sheet_1 is not in the same order as the text column in sheet_2. All columns contain thousands of rows.
In the past, just a couple of days ago on the same computer and in the same Excel program, I successfully used this formula:
In the past use of this formula, it would successfully match the text of number in sheet_2, cell A1 to the text or number in sheet_1, column A, return the corresponding value or number in the cell from the indexed column B in sheet_2 to the cell I placed the formula. If there was not a match found, then the formula would return the text "Not Found."
Even if I go back to where I have used the formula successfully and retype the exact same formula OR cut and paste it, sometimes it will work and sometimes it will not.
I have tried reformatting all the columns to text using the text to columns function. I have tried copying into Notepad and then pasting back into the worksheet. I have tried different variations of formulas I have found online and cannot get anything to work.
At this point if I get a "N/A" instead of "Not Found," I would be happy.
Thank you, Cooper