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.

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.

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.

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