I realized later about the titles, and made another post with the INDEX
function. I was too happy to have got the formula to run, that I forgot
about the final part :-)

Miguel.

"CLR" wrote:

Thanks Miguel, that seems to work pretty good as you describe. But in this
instance, I want the result to be the "Titles" from the Row and Column,
rather than it's relative number.


Vaya con Dios,
Chuck, CABGx3



"Miguel Zapico" wrote:

You can use matrix multiplication to get the result. Supposing your matrix
is in B3:F7, and the value to you want to locate is in A10, you can use
=MATCH(1,MMULT(--(B3:F7=A10),{1;1;1;1;1}),0) (gives the row, from 1 to 5)
=MATCH(1,MMULT({1,1,1,1,1},--(B3:F7=A10)),0) (gives the column, from 1 to 5)

You don't need to introduce them as array formulas, they just use arrays as
arguments.

Hope this helps,
Miguel.

"CLR" wrote:

Hi All......
I have a small 5x5 matrix on a worksheet. Normally one supplies the Row
and Column Titles of a matrix to return the crossover value. I want to do it
in reverse. I want to supply the crossover value and in return get the Row
and Column Titles from the matrix, (not the Excel cell address).

TIA for any assistance,
Vaya con Dios,
Chuck, CABGx3