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