Hi!
If I understand, try this:
A4 = 01-06-06
=HLOOKUP(B$4,INDIRECT("'"&A4&"'!D10:P111"),102,FAL SE)
Biff
"lmullenjr" wrote
in message ...
I am trying to use an HLOOKUP on a summary spreadsheets with various
spreadsheets behind it. Each of the individual spreadsheets behind the
summary would have a name as follows:
01-06-06
01-13-06
01-20-06
In column a of the summary spreadsheet I was planning to have the name
of a spreadsheet behind it similar to the above.
I then wanted to do an hlookup as follows:
HLOOKUP(B$4,'01-06-06'!$D$10:$P$111,102,FALSE)
Where B$4 would have the column header in the table array. Where I
have the row_index_number referecing the worksheet name (i.e.
'01-06-06') I wanted to write a formula to select what was in column a.
I tried to use a concatenate formula, but I can't seem to get it to
work.
Any help or ideas would be appreciated!
LMULLEN
--
lmullenjr
------------------------------------------------------------------------
lmullenjr's Profile:
http://www.excelforum.com/member.php...o&userid=33132
View this thread: http://www.excelforum.com/showthread...hreadid=572936