You can add IF(ERROR.TYPE=4),"",.... (normal formula) to your formula to
return a blank if the error type in the source cell is #REF!. Look up
ERROR.TYPE in help for more information about which digits apply to
which ERROT.TYPEs.

The formula I use this in is
=IF(ERROR.TYPE(VLOOKUP($A26,Worksheet!$C$2:$H$45,2 ,FALSE)=4),"",VLOOKUP($A26,Worksheet!$C$2:$H$45,2, FALSE))

Hope this helps :)


--
tuph
------------------------------------------------------------------------
tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390
View this thread: http://www.excelforum.com/showthread...hreadid=525939