LONG VLOOKUP

  • Thread starter Thread starter lehigh46
  • Start date Start date
L

lehigh46

Hi All,


Is it possible to do a VLOOKUP of a list that is 4 or 5 times as long
(273,616 rows long) as there are rows on an Excel sheet.

I could place each length of data on a seperate sheet in the same
wookbook, or I could place all of the dada on the same sheet.

Each length of data is 3 columns wide.

Thanks for your help.


Tom Snyder
 
With that sized data I would use a database and query in excel

you can use a vlookup over multiple sheets like

=IF(ISNUMBER(MATCH(A1,Sheet2!A2:A65000,0)),VLOOKUP(A1,Sheet2!A2:B65000,2,0),IF(ISNUMBER(MATCH(A1,Sheet3!A2:A65000,0)),VLOOKUP(A1,Sheet3!A2:B65000,2,0),IF(ISNUMBER
and so on

however me thinks it would be extremely slow for any practical use
 

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

Need VLOOKUP to Work Two Ways 0
Vlookup and return sheet name also 2
VLOOKUP 1
Vlookup Help 2
Why can't I sum several vlookups ?? 5
Vlookup - multiple tabs 5
Checking the lower row of vlookup() 2
SUM with nested VLOOKUPS - can i make it ignore N/As? 5

Back
Top