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
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