ISERROR

[Jim]

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

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

I have been trying, but to no avail.

 

[Mike H]

Maybe,

=IF(ISERROR(IF(B59>1,VLOOKUP(A59,$D$3:$S$2423,14,FALSE),"
")),"",IF(B59>1,VLOOKUP(A59,$D$3:$S$2423,14,FALSE)," "))

Mike

 

[Gord Dibben]

I recommend not using ISERROR which would mask all errors.

I think you just need the ISNA function.

=IF(ISNA(IF(B59>1,VLOOKUP(A59,$D$3:$S$2423,14,FALSE))),"",IF(B59>1,VLOOKUP(A59,$D$3:$S$2423,14,FALSE)))


Gord Dibben MS Excel MVP

 

[Jim]

Thanks.

I recommend not using ISERROR which would mask all errors.

I think you just need the ISNA function.

=IF(ISNA(IF(B59>1,VLOOKUP(A59,$D$3:$S$2423,14,FALSE))),"",IF(B59>1,VLOOKUP(­A59,$D$3:$S$2423,14,FALSE)))

Gord Dibben  MS Excel MVP







- Show quoted text -