Thank you so much - worked great! Being a bit of a novice, showing me the
extra closed parenthesis was especially helpful.

Have a great day!
--
Julie


"Peo Sjoblom" wrote:

Change your formula to

=IF(ISNA(VLOOKUP()),"",VLOOKUP())

obviously put your real data in there


with regards to the value error, that is not because of the lookup, it's
because somewhere you are trying to calculate with text. You need to find
that and correct it. Press F5, special and select formulas and deselect
everything but errors, that will select all formulas with errors


--
Regards,

Peo Sjoblom


"Julie" wrote in message
...
I'm trying to replace two error messages (#N/A and #VALUE!) found
throughout
my spreadsheet. The error messages are a result of lookups that cannot
find
values on my look up tables. I would like those cells to show up as blank
for reporting purposes.

I tried to do a find and replace. I did a find ...look in...values...find
all. The cells were all found. I leave the replace box blank and click on
replace all and get an error message. After trying several times, I find
that the "look in" box on the replace page no longer has values
highlighted
and fact values doesn't even show up.

How can I replace all the look up error messages with blank cells?


--
Julie