I recommend not using ISERROR which would mask all errors.

I think you just need the ISNA function.

=IF(ISNA(IF(B591,VLOOKUP(A59,$D$3:$S$2423,14,FALS E))),"",IF(B591,VLOOKUP(A59,$D$3:$S$2423,14,FALSE )))


Gord Dibben MS Excel MVP


On Tue, 23 Sep 2008 07:33:30 -0700 (PDT), Jim wrote:

Can anyone tell me how to get the ISERROR function in this function:

=IF(B591,VLOOKUP(A59,$D$3:$S$2423,14,FALSE)," ")

I have been trying, but to no avail.