| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup not looking through all the values
I have a large sheet, 27,000+ lines. It's just a list of rates for
combinations of origin and destination zipcodes. For some reason vlookup is not looking up zipcodes that go beyond 71000+ or so. I also applied the autofilter, and after scrolling through the fliter list, the values there also stop at 71000 even though the values clearly go to 99000+ when you go to the end of the sheet. Is there a limit on how many unique values you can actually look up? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with 2 values | Excel Worksheet Functions | |||
| Vlookup and Values | Excel Worksheet Functions | |||
| Can you use 2 look up values in VLookup? | Excel Worksheet Functions | |||
| VLOOKUP USING 2 LOOK UP VALUES | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
Threaded Mode
