Perhaps this way may be easier on the logic but it requires an AddIn to be
downloaded and installed. The MoreFunc AddIn has a function called THREED
which changes a 3D range into a 2D range.

Your formula could look like this
=VLOOKUP(A1,THREED(Sheet2:Sheet5!$A$1:$C$65536),3, FALSE)

The Addin can be found here http://xcell05.free.fr/

Cheers!

Richard

"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