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