whats wrong with the formula?

[Gary]

=IF(ISNA(VLOOKUP(A3,Sheet2!A1:B12,2,FALSE)),"No Results
Found",(VLOOKUP(A3,Sheet2!A1:B12,2,FALSE)))

Always returning "No Results Found".

Please help

 

[Tarek]

Hi,

I guess u r missing to use $ in the vlookup! try below:
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$B$12,2,FALSE)),"No Results
Found",(VLOOKUP(A3,Sheet2!$A$1:$B$12,2,FALSE)))

Thanks,
Tare

 

[Pete_UK]

You are looking for an exact match. Check the values in Sheet2 column A
to see that you have no spurious spaces at the beginning or end. Ensure
that the value in A3 has no extra spaces.

Hope this helps.

Pete