0

I have 3 columns (Col1, Col2, Col3). All 3 columns are in their own worksheet (WS1, WS2, WS3).

I want to

  1. search each cell in Col1
  2. see if that cell matches anything within Col2 in WS2 then output "WS2"
  3. if nothing in Col2, then see if that cell matches anything within Col3 in WS3 then output "WS3"

Hope this is enough information

  • share a copy of your sheet – user0 Mar 7 at 20:29
  • I cannot share this due to confidentiality – manc Mar 8 at 11:43
  • your question has multiple meanings... try to explain it better. if you can not share a copy of your actual sheet due to confidentiality, consider creating a dummy sheet with fake data which will mimic your setup so we could understand the structure of your dataset – user0 Mar 8 at 11:47
  • Created dummy data for you: docs.google.com/spreadsheets/d/… – manc Mar 8 at 13:22
0

=ARRAYFORMULA(IFERROR(IFERROR(
 IF(VLOOKUP(A2:A, 'WS2'!A1:A, 1, 0)<>"", "WS2", ),
 IF(VLOOKUP(A2:A, 'WS3'!A1:A, 1, 0)<>"", "WS3", )), ))

0

  • YES! Thanks so much – manc Mar 8 at 18:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.