vlookup not looking through all the values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return the value from the look up value sheet 1
Microsoft Excel - Looking up values from a range by selection by scroll of arrow keys. 1
Vlookup-Doesn't return values under 1 1
VLOOKUP Function to return values in multipal Columns 6
using strings in vlookup function calls 5
VLOOKUP DUPLICATE VALUES 3
vlookup issue 2
IF & VLOOKUP 4

Back
Top