It sounds like the cell's value that you were returning really had that divide
by 0 error.

jane wrote:

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


--

Dave Peterson