=IF(ISNA(VLOOKUP

[faeryluv]

I'd like to compare the names on Sheet 2 to the names on Sheet 1.
I would like it to return a Yes or No depending on if any of the names from Sheet 2 are on Sheet 1.
I'm using any rows with a "No" to Query onto another Sheet so that's why I need it this way.

Formula I'm using that is returning an ERROR:
=IF(ISNA(VLOOKUP(A3 or B3,Sheet1!A:A,1,FALSE)), "No", "Yes")

Thanks in advance!

 

[Joe4]

Here is one way:
=IF(ISNA(IFERROR(VLOOKUP(A3,Sheet1!A:A,1,FALSE),VLOOKUP(B3,Sheet1!A:A,1,FALSE))),"No","Yes")

 

[DanteAmor]

Try this

=IF(IFERROR(MATCH(A2,Sheet1!A:A,0),IFERROR(MATCH(B2,Sheet1!A:A,0),0)),"Yes","No")

 

[Luiz_Wiese]

I'd like to compare the names on Sheet 2 to the names on Sheet 1.
I would like it to return a Yes or No depending on if any of the names from Sheet 2 are on Sheet 1.
I'm using any rows with a "No" to Query onto another Sheet so that's why I need it this way.

Formula I'm using that is returning an ERROR:
=IF(ISNA(VLOOKUP(A3 or B3,Sheet1!A:A,1,FALSE)), "No", "Yes")

View attachment 3323

Thanks in advance!

Hi @faeryluv,

The answer is already on the "OR" you put inside your Formulas. I Imagine that it is a YES with one or two names from Sheet2 contained in Sheet1 and NO only if none of the names on the rows are present, correct? Check the OR Formula and instead of looking for Errors with ISNA check for valid matches with ISTEXT.

Here's my suggestion:

=OR(ISTEXT(VLOOKUP(Sheet2!$A3, Sheet1!A:A, 1, FALSE)), ISTEXT(VLOOKUP(Sheet2!$B3, Sheet1!A:A, 1, FALSE)))

This way you can check if condition 1 (A3 Entry) or condition 2 (B3 Entry) are inside Column A from Sheet1
Tried here and worked. Let me know if it's working for you too.

Edit: It is not "row Locked" so you can pull the formula to all the needed rows with names

 

[BrianM]

=IF(OR(SUMPRODUCT(--(Sheet1!A1:A500=Sheet2!A3)),SUMPRODUCT(--(Sheet1!A1:A500=Sheet2!B3)))=TRUE,"Yes","No")

 

[faeryluv]

Wow, everyone! Thank you all for your quick replies, I really appreciate it. I tried the first reply, and it worked great! I did copy down the other replies too, just in case ?