Hlookup

[lmullenjr]

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

[Biff]

Hi!

If I understand, try this:

A4 = 01-06-06

=HLOOKUP(B$4,INDIRECT("'"&A4&"'!D10:P111"),102,FALSE)

Biff

"lmullenjr" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[lmullenjr]

Thanks so much! I missed the INDIRECT part!

[Biff]

You're welcome!

Biff

"lmullenjr" <[email protected]> wrote
in message news:[email protected]...
>
> Thanks so much! I missed the INDIRECT part!
>
>
> --
> lmullenjr
> ------------------------------------------------------------------------
> lmullenjr's Profile:
> http://www.excelforum.com/member.php...o&userid=33132
> View this thread: http://www.excelforum.com/showthread...hreadid=572936
>