Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Select by multiple criteria (Excel 2003)
How do I search for a value in a table based on variable row names and column
names? I have a table with rows that are labeled 1-11 and columns that are labeled 1-6. I need to retrieve a value from the table that may have reference of row 3 and column 4, or row 1 and column 6 and so on and the references are in other cells adjacent to my formula cell. I'm trying to build a formula in a cell on another worksheet that will search and retrieve this data from a table on another worksheet. |
#2
|
|||
|
|||
Hi!
Take your pick.... Table is in the range A1:G12 A15 = row reference 3 A16 = column reference 4 =VLOOKUP(A15,A2:G12,MATCH(A16,A1:G1,0),0) =INDEX(B2:G12,MATCH(A15,A2:A12,0),MATCH(A16,B1:G1, 0)) Biff "Picman" wrote in message ... How do I search for a value in a table based on variable row names and column names? I have a table with rows that are labeled 1-11 and columns that are labeled 1-6. I need to retrieve a value from the table that may have reference of row 3 and column 4, or row 1 and column 6 and so on and the references are in other cells adjacent to my formula cell. I'm trying to build a formula in a cell on another worksheet that will search and retrieve this data from a table on another worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to generate a report from multiple lists in Excel 2003? | Excel Discussion (Misc queries) | |||
Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
How can I Insert a Comment into multiple cells in Excel 2003? | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel |