I have data in two sheets within a workbook. I need to compare data in a cell from one sheet to data in a column on second sheet and return the value of a third cell in the row associated with the match on the second sheet.
I am uploading a sample as an illustration. In this example I need a formula in c3 on sheet 2 that will compare the text in b3 on sheet 2 with the text in column c on sheet 1. The values in these columns are all unique. When a match is found in the text in column c on sheet 1, I need the formula to return the text in the associated cell from column a on sheet 1.
In my example, b3 = **None** on sheet 2. I need the formula in c3 to scan column c on sheet 1 and find the cell that = **None** and return the value from column on the same row, in this case Non Income Other.
Sample.xlsx
Bookmarks