Formula not working

[rootsrules]

Hi everyone!

I am trying to use this formula:
=if(VLOOKUP(A2,'2021 Final Registered'!$A$2:$B$1000,2,false)=A2,"Yes","No")
But the result is #N/A.
I am trying to check if a certain cell that contains a name is on the list from another tab.
If so, then the result comes out Yes (which is working fine).
However, when the result did not find the name, then it gives me #N/A instead of No.
Is there a solution for this?
Also, I am using Google Sheets instead of Excel... (sigh)

Thank you!

 

[SpillerBD]

You want IF(ISERROR(VLOOKUP()....

 

[rootsrules]

You want IF(ISERROR(VLOOKUP()....

I input:
=if(ISERROR(VLOOKUP(A2,'2021 Final Registered'!$A$2:$B$1000,2,false)=A2,"Yes","No"))
And an error message came out:
Wrong number of arguments to IF. Expected between 2 and 3 arguments, but got 1 argument.

 

[ebea]

Put your iferror in so: =iferror(if(VLOOKUP(A2,'2021 Final Registered'!$A$2:$B$1000,2,false)=A2,"Yes","");"No")

 

[jtakw]

Hi,

I'm thinking, why are you using VLOOKUP

If Both A & B Column in '2021 Final Registered' sheet needs to match A2 on the same row, use:

=IF(COUNTIFS('2021 Final Registered'!$A$2:$A$1000,A2,'2021 Final Registered'!$B$2:$B$1000,A2),"Yes","No")

If Only B Column in '2021 Final Registered' sheet needs to match A2, use:

=IF(COUNTIF('2021 Final Registered'!$B$2:$B$1000,A2),"Yes","No")

 

[rootsrules]

Thank you everyone! It worked!

 

[jtakw]

You're welcome.