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
|