The current cell data is the result of the formula, ant previous value has
been over-written.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
Hi:
When I use this formula -

IF(ISNA(VLOOKUP(D9,$A$2:$B$15,2,FALSE)),,(VLOOKUP( D9,$A$2:$B$15,2,FALSE)))
The cell return is 0.

IF(ISNA(VLOOKUP(D9,$A$2:$B$15,2,FALSE)),"
",(VLOOKUP(D9,$A$2:$B$15,2,FALSE)))
The cell return is BLANK.

What I want is for the current cell data to remain, if the
"IF<ISNA<VLOOKUP" function is TRUE instead of the notorious #NA, Blank,
and "0" returns.

What should I do?
Please help.
Thanks,
Jay