Lookup in a list of number with a headline
 

I have several sheets for months that I want to sum up in one sheet. I use
the formula = if(iserror(vlookup..) and so on. The formula is correct except
when the number I want is the first number in the lookup list. (Row 2) The
numbers are NOT in order, not in the monthly sheet or in the summing up, and
the order of customernumber is different in all sheets.

If I try the same in an ordered list, there's not a problem with this.

Ex from the lookuplist:

Column N:
Customer
185449
203920
115109

Hi Traima

A vlookup formula has 4 arguments
=vlookup("what", "where", "column no of the desired result in the
lookup table", "what if not found")
It seems that you are not entring the last arguement. Enter the last
argument as False or 0. This will tell the function to lookup for exact
match. If this argument is left (as it is optional), excel will try to
find the closest match... and put that value).

Now try this and let me know if this solves your problem.....

Thanks
Karthik Bhat
Bangalore

Thanks for your response, but it didn't solve the problem - I've got the
last part of the vlookup-formula like the one you described. Any other
suggestions?

Karthik skrev:

Hi Traima

A vlookup formula has 4 arguments
=vlookup("what", "where", "column no of the desired result in the
lookup table", "what if not found")
It seems that you are not entring the last arguement. Enter the last
argument as False or 0. This will tell the function to lookup for exact
match. If this argument is left (as it is optional), excel will try to
find the closest match... and put that value).

Now try this and let me know if this solves your problem.....

Thanks
Karthik Bhat
Bangalore