Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hlookup
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hlookup
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hlookup
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hlookup
You're welcome!
Biff "lmullenjr" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and hlookup | Excel Worksheet Functions | |||
Problem with HLookup - Sometimes works, sometimes blank. | Excel Discussion (Misc queries) | |||
Index / Hlookup | Excel Worksheet Functions | |||
Sorting on cells containing HLOOKUP | Excel Worksheet Functions | |||
Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions |