Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LONG VLOOKUP
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 |
#2
|
|||
|
|||
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,She et3!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 -- Regards, Peo Sjoblom "lehigh46" wrote in message ... 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 |
#3
|
|||
|
|||
And see one very similar response to your other post.
lehigh46 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions | |||
Using Cell references in VLookUp | Excel Worksheet Functions |