vlookup with table array - help

[fayez_MrExcel]

Why im getting #n/a if the logic is false, i want to have "wrong" if the value is false. help please:

This code is placed in Sheet1_B2

=IF(VLOOKUP(A2,'sheet2'!A2:A215,1,FALSE)=A2,"Correct","Wrong")

 

[fairwinds]

Hi,

Try:

=IF(ISNUMBER(MATCH(A2,Sheet2!A2:A215,0)),"Correct","Wrong")

 

[fayez_MrExcel]

thanks a lot : )