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?