Results 1 to 4 of 4

vlookup longer than 65000 rows

This is a discussion on vlookup longer than 65000 rows within the Excel Questions forums, part of the Question Forums category; Help! I have a data set of aprox 90,000 rows that i need ot run a vlookup on. As the ...

  1. #1
    New Member
    Join Date
    Oct 2009
    Posts
    2

    Default vlookup longer than 65000 rows

    Help! I have a data set of aprox 90,000 rows that i need ot run a vlookup on. As the excel is limited to 65,000 rows is there any way i can have the lookup continue in the next columns? (ie. data running from a1-a65000, then continue in b1-b25000)

  2. #2
    Board Regular
    Join Date
    Mar 2009
    Location
    St. Louis, MO
    Posts
    1,561

    Default Re: vlookup longer than 65000 rows

    With that much data to compare have you considered putting it into an Access Database to run your comparison? No row limit in Access.
    Never stop learning

    Excel 2013 Windows 7 (work)
    Excel 2007 Windows XP (home)

  3. #3
    New Member
    Join Date
    Oct 2009
    Posts
    2

    Default Re: vlookup longer than 65000 rows

    thanks for the reply, yes considered that but, unfortunately the final file will be a user tool and the end users do not have Access, so the tool need to be built in excel.

  4. #4
    Board Regular
    Join Date
    Sep 2005
    Posts
    135

    Default Re: vlookup longer than 65000 rows

    If you do want to do it in Excel, it might take a while to calculate, but you could do it by adding IF logic to the lookup.

    =IF(ISNA(VLOOKUP(E9,G:G,1,FALSE)),VLOOKUP(E9,H:H,1,FALSE),VLOOKUP(E9,G:G,1,FALSE))

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com