In the adjacent cell (in this case G1) to your text "GM" where your
table is in A1:B10.

=IF(ISNA(VLOOKUP(F1,A1:B10,2,FALSE)),"",VLOOKUP(F1 ,A1:B10,2,FALSE))

This returns a blank if the value is not found in the table.

HTH

Steve


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