Need to find the value within a matrix / table based on two other values
 

I have a 9 x 10 table in excel that holds txt strings e.g "BRC",
"BPC". There are 9 rows and 10 columns. Outside of this size table, I
have headings for each column and row (so it is a 10 x 11 table if you
include the row and column names). Each cell within the table has a
corresponding row and column heading name e.g row 1's name is OFF, row
2 is WT_STEDY.....column 1 is Blend Closed, column 2 is Steady State.
There is a text string that goes with each combination of heading
names e.g. the string for row 2 and column 1 (WT_STEDY, Blend Closed)
is "BRC".

I would like to be able to feed the names of the two corresponding
heading names into some kind of lookup formula that will then return
me the string of the cell in the matrix to which they both correspond.
The heading names would themselves be fed from two cells elsewhere in
the spreadsheet. How do I go about doing this?

Regards,

Tom Pritchard

Need to find the value within a matrix / table based on two other
 

=index(A1:K10,match(M1,A1:A10,0),Match(N1,A1:K1,0) )
Assume M1 holds "WT_STEDY" and N1 holds "Blend Closed"
as examples.

--
Regards,
Tom Ogilvy


"Tommy" wrote:

I have a 9 x 10 table in excel that holds txt strings e.g "BRC",
"BPC". There are 9 rows and 10 columns. Outside of this size table, I
have headings for each column and row (so it is a 10 x 11 table if you
include the row and column names). Each cell within the table has a
corresponding row and column heading name e.g row 1's name is OFF, row
2 is WT_STEDY.....column 1 is Blend Closed, column 2 is Steady State.
There is a text string that goes with each combination of heading
names e.g. the string for row 2 and column 1 (WT_STEDY, Blend Closed)
is "BRC".

I would like to be able to feed the names of the two corresponding
heading names into some kind of lookup formula that will then return
me the string of the cell in the matrix to which they both correspond.
The heading names would themselves be fed from two cells elsewhere in
the spreadsheet. How do I go about doing this?

Regards,

Tom Pritchard