In Excel I have 3 sheets in the same workbook.
- I want to compare column A on "Sheet 1" with Column B on "Sheet 2" and Column b on "Sheet 3".
- If I find an exact match on anywhere in column B "Sheet 2" I want cell B next to the compared value on "Sheet 1" column A to say "Sheet 2"
- If I find an exact match on anywhere in column B "Sheet 3 I want cell B next to the compared value on "Sheet 1" column A to say "Sheet 3"
The following formula works perfectly to compare only sheet 2 but I cannot figure out how to modify it to work and compare values on both sheet 2 and sheet 3.
=IF(ISERROR(MATCH(A2,'Sheet 2'!$b$2:$b$30,FALSE)),"","Sheet 2")
Please see the images below.
Current results:
End results: