whats wrong with the formula?

G

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
 
T

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
 
P

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
 
Top