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