| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieving info from multiple tables
I have a worksheet with three Tables (Table1, Table2, and Table3), 10 rows by
5 Columns. In cell A1, List: Table1, Table2 and Table3 In cell B1, List: A, B, C, D, E, F, G, H, I, J (First Column in each table) In cell B2, VLOOKUP(B1,A1,2) (Looking for the value in the 2nd Column depending on which table I choose in cell A1) Repeat B3, B4, B5 Column increase by 1 for VLOOKUP Problem is VLOOKUP will not allow a cell such as A1, it wants one table name. The Tables will be hidden Respectfully, Paul M. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving info from multiple tables
Hi
Try =VLOOKUP(B1,INDIRECT(A1),2) -- Regards Roger Govier "PMaravy" wrote in message ... I have a worksheet with three Tables (Table1, Table2, and Table3), 10 rows by 5 Columns. In cell A1, List: Table1, Table2 and Table3 In cell B1, List: A, B, C, D, E, F, G, H, I, J (First Column in each table) In cell B2, VLOOKUP(B1,A1,2) (Looking for the value in the 2nd Column depending on which table I choose in cell A1) Repeat B3, B4, B5 Column increase by 1 for VLOOKUP Problem is VLOOKUP will not allow a cell such as A1, it wants one table name. The Tables will be hidden Respectfully, Paul M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching multiple columns and retrieving a value | Excel Worksheet Functions | |||
| Retrieving a specific cell from multiple worksheets | Excel Worksheet Functions | |||
| Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions | |||
| Retrieving an Item from a List that Meets Multiple Criteria | Excel Worksheet Functions | |||
| Retrieving a Value from List that meets multiple Criteria | Excel Discussion (Misc queries) | |||
Linear Mode
