Here is a sample that should help.

__ A ______ B___C______ D___
1| NO MATCH__________________
2|__________4___1_______11
3|______________3_______33
4|______________5_______55
5|______________7_______77


the formula in A1 is:
=IF(COUNTIF(C2:C5, B2) 0, VLOOKUP(B2,C2:D5,2,FALSE), "NO MATCH")


--
UofMoo
------------------------------------------------------------------------
UofMoo's Profile: http://www.excelforum.com/member.php...o&userid=26485
View this thread: http://www.excelforum.com/showthread...hreadid=397987