whats wrong with the formula?
 

=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

whats wrong with the formula?
 

Hi,

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

Thanks,
Tarek


--
Tarek
------------------------------------------------------------------------
Tarek's Profile: http://www.excelforum.com/member.php...fo&userid=6325
View this thread: http://www.excelforum.com/showthread...hreadid=567764

whats wrong with the formula?
 

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

Gary wrote:
=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