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
|