Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel matrix
I want to enter two enter two pieces of data in separate cells and have it
return a value from a table that is the intersection ofthe 2 axis. |
#2
|
|||
|
|||
To be more specific:
I have a table that has numbers across the top row and letters in the first column. I want to enter a number and a letter and get a value of wher the two pieces of data intersect "Moneywiz2004" wrote: I want to enter two enter two pieces of data in separate cells and have it return a value from a table that is the intersection ofthe 2 axis. |
#3
|
|||
|
|||
Hi
see: http://www.contextures.com/xlFunctions03.html -- Regards Frank Kabel Frankfurt, Germany Moneywiz2004 wrote: I want to enter two enter two pieces of data in separate cells and have it return a value from a table that is the intersection ofthe 2 axis. |
#4
|
|||
|
|||
Moneywiz2004 wrote:
To be more specific: I have a table that has numbers across the top row and letters in the first column. I want to enter a number and a letter and get a value of wher the two pieces of data intersect "Moneywiz2004" wrote: I want to enter two enter two pieces of data in separate cells and have it return a value from a table that is the intersection ofthe 2 axis. You may want to investigate the Intersection Operator. It might suggest that you want text names instead of just letters and numbers as the row and column headers. Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
How do I print a file holder label from Excel to a dox matrix pri. | Excel Discussion (Misc queries) |