| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
why won't vlookup work in a long list
I have a list in Excel that is reasonably long, VLOOKUP won't pick up some of
the end items. If I move the reference up the list it will work. However if I leave it at the end and remove a large middle section of the list, it will still not work. All formulae have been copied, I have reformatted all the cells the same, names (database) in the formula have a big enough reference. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to run series of reports to PDF | Excel Worksheet Functions | |||
| Work with list to make 3rd column | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| need help finding a Date range within long list | Excel Worksheet Functions | |||
| Comparing a value to a list of values does not work in Excel 2003. | Excel Worksheet Functions | |||
Threaded Mode
