#1   Report Post  
Old April 3rd 05, 08:44 PM
lehigh46
 
Posts: n/a
Default 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   Report Post  
Old April 3rd 05, 09:18 PM
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
Old April 3rd 05, 11:46 PM
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make a vlookup using a variable path Alex St-Pierre Excel Worksheet Functions 1 March 3rd 05 12:54 AM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 01:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 11:43 AM
VLOOKUP not working Scott Excel Worksheet Functions 3 November 12th 04 09:06 PM
Using Cell references in VLookUp JonWilson631 Excel Worksheet Functions 1 November 4th 04 03:49 AM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017