is blank AND is error
That did it! thanks!
(ps... I changed the ISNA to ISERROR to take care on a DIVO that showed up)
take care, Jane
"Dave Peterson" wrote:
Maybe...
=if(isna(vlookup(...)),"",if(vlookup(...)="","",vl ookup(...)))
You could even make it a little more informative:
=if(isna(vlookup(...)),"No match",if(vlookup(...)="","",vlookup(...)))
And if you really wanted to return "" if either there was no match or the cell
was empty:
=if(iserror(1/len(vlookup(...)),"",vlookup(...))
jane wrote:
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
--
Dave Peterson
|