Put this in Sheet1, B1
=IF(COUNTIF(Sheet2!$A:$A,A1)0, VLOOKUP(A1,Sheet2!$A:$B,2,FALSE), "")
You have to put the if statement in there or else you are going to get
#N/As
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=562917