Try this:

=IF(ISERROR(vlookup(…))=TRUE,"",vlookup(…))

(It says: If Vlookup is giving an error, put in a "" (blank), if it
does not give an error, it does the actual look up)


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=543359