Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Define and Reference fixed data in a table
Hi All
I'm new to Excel and would like to know if it's possible to do the following: Define a table(2 dimensional array) of fixed data like this: Tom Dick Harry Alpha 10 7 5 Bravo 6 27 4 Charlie 17 22 8 I'd then like to be able to reference each element in the array using the row and column identifiers as indexes, so (Alpha, Harry) would return 5, (Charlie,Harry) would return 8 and so on. Tia RH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define chart range using indirect reference | Charts and Charting in Excel | |||
Define Name reference | Excel Worksheet Functions | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Fan charts | Charts and Charting in Excel | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions |