HI,

I am looking to add numbers from 18 different work sheets. Not all of the
values are contained in every worksheet. In other words I need to make up a
summary sheet adding up all the values in all of the other sheets.

Since If LOOKUP can't find the lookup_value, it matches the largest value in
lookup_vector that is less than or equal to lookup_value.

This is creating a problem. What I want to do is if that lookup value is
not in the lookup vector, I would like them to return a value of either 0, or
just nothing at all.

Can someone please help me figure out how to do this, its been driving me
crazy.

Thanks

Hi

What's the format of all the sheets (and are they identical)? What
values need to be looked up (what are the cell refs? Same every
sheet?) and are there any other criteria that needs to be applied eg
only sum cells with a corresponding "Balance" in the column next to
the value to be summed).

This will make it an awful lot easier for me/others to provide an
answer!

Richard


M. J. Kroll wrote:
HI,

I am looking to add numbers from 18 different work sheets. Not all of the
values are contained in every worksheet. In other words I need to make up a
summary sheet adding up all the values in all of the other sheets.

Since If LOOKUP can't find the lookup_value, it matches the largest value in
lookup_vector that is less than or equal to lookup_value.

This is creating a problem. What I want to do is if that lookup value is
not in the lookup vector, I would like them to return a value of either 0, or
just nothing at all.

Can someone please help me figure out how to do this, its been driving me
crazy.

Thanks

At the end of your Vlookup (i assume that is what you are using) add a false,
this will only return exact matches.
e.g.
=VLOOKUP(A1,B1:B5,2,FALSE)
substitute your data

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"M. J. Kroll" wrote:

HI,

I am looking to add numbers from 18 different work sheets. Not all of the
values are contained in every worksheet. In other words I need to make up a
summary sheet adding up all the values in all of the other sheets.

Since If LOOKUP can't find the lookup_value, it matches the largest value in
lookup_vector that is less than or equal to lookup_value.

This is creating a problem. What I want to do is if that lookup value is
not in the lookup vector, I would like them to return a value of either 0, or
just nothing at all.

Can someone please help me figure out how to do this, its been driving me
crazy.

Thanks