RayB,

Where you want the location to be for A2 in Sheet!1 enter,

=IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$B$3000,2,FALSE)), "",VLOOKUP(A2,Sheet2!$A$2:$B$3000,2,FALSE))

This will return a blank if the value in A2 is not found.



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=562560