Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with ISERROR | Excel Worksheet Functions | |||
iserror | Excel Worksheet Functions | |||
Iserror & VBA | Excel Discussion (Misc queries) | |||
ISERROR - #NAME? | Excel Worksheet Functions | |||
iserror | Excel Discussion (Misc queries) |