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: