| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is blank AND is error
This is my formula
'=IF(ISBLANK(VLOOKUP($L11,'Past RDW '!$L$3:$AI$780,16,FALSE)),"",(VLOOKUP($L11,'Past RDW '!$L$3:$AI$780,16,FALSE))) I am getting #NA when there is not a match so need to have a combo of isblank and iserror... is this possible? thanks in advance! jane |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace error with blank | Excel Worksheet Functions | |||
| blank error | Excel Worksheet Functions | |||
| error when blank - please help | Excel Discussion (Misc queries) | |||
| #DIV/0! Error - Need to display 0 or blank | Excel Worksheet Functions | |||
| Leave Cell Blank if value is an error, below 0 or above 80 | Excel Discussion (Misc queries) | |||
Threaded Mode
