Can the lookup return a zero deriving from a zero in the lookup column, if
not you can simply use a custom format to hide the zeros

General;-General;

or


0.00;-0.00;

can of course be done with currency format as well



will not display zeros

that way you don't have to change the formulas


--
Regards,

Peo Sjoblom



"Julie" wrote in message
...
If I could bother you with one more question, please. As I said in my
last
post, your answer worked perfectly for me. Now, I need to know what to do
when my lookup puts a zero (0) in a cell when the lookup found a blank
cell.
I would like it to be blank if the lookup found a blank cell. Can you
help
me with that too?--
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