If we use ISERROR to trap error messages, we can prevent them from
showing up, as such:
=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",V LOOKUP(B2;Internal!B:C;2;FALSE)
The first part of the formula looks to see if the result is an error
and if so, returns the empy string "". If no error is found, the
result of the formula is returned.
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=384575