Lookups and the next smallest value

M

M. J. Kroll

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
 
R

RichardSchollar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top