3D Ranges

[Tushar Mehta]

I have some unfortunate news for you. Searching the "utterly useless"
help for the keywords '3d range' (w/o the quotes) leads to the topic
'Refer to the same cell or range on multiple sheets,' which contains
the section 'Functions that can be used in a 3-D reference'. Neither
VLOOKUP nor HLOOKUP is listed in it.

That said...

Who do you work for? A legacy airline? What do you do that requires a
price list with more than 65536*256 entries? If nothing else,
maintaining that with any degree of accuracy must be a nightmare. ;-)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

Actually I work for a fund management company and we mainatin historical
daily prices on the traded stocks we monitor. The prices are used for back
testing as well as generating technical signals for current trades - MACD
etc. Excel constrains us to 256 days of history if we stack the stock
horizontally or 256 stocks if we stack the stocks in columns. My thought was
that one could create and enlarged named range crossing 2-3 sheets allowing
me to run price history on the several hundred stocks we cover. From what you
are saying this may not be possible. Do you have any ideas?