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?

vlookup not looking through all the values
 

Check for empty spaces on your value to be looked up and in the table
reference where the values are to be returned from, you may even want to use
the trim Formula to eliminate the blank spaces or do a find and replace of
those blank spaces.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"vlad" wrote:

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?