Just a head's up on ISERROR
It will mask all errors, not just the #N/A and may hide something you don't
want hidden.
Preferable to use the ISNA function.
=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOO KUP(B2;Internal!B:C;2;FALSE)
Gord Dibben Excel MVP
On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
wrote:
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)),"", VLOOKUP(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
|