I have 3 columns (Col1, Col2, Col3). All 3 columns are in their own worksheet (WS1, WS2, WS3).
I want to
- search each cell in Col1
- see if that cell matches anything within Col2 in WS2 then output "WS2"
- if nothing in Col2, then see if that cell matches anything within Col3 in WS3 then output "WS3"
Hope this is enough information