| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Applying Value To Text Selection In List Box | New Users to Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| can lookup a number to a 10x10 table? | Excel Worksheet Functions | |||
| Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
Threaded Mode
