ISERROR
 

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.

ISERROR
 

Maybe,

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

Mike

"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.

ISERROR
 

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.

ISERROR
 

Thanks.

On Sep 23, 1:00*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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,FALS E)))

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.- Hide quoted text -

- Show quoted text -