Assumptions:

B1:E1 contains the column labels

A2:A5 contains the row labels

B2:E5 contains the data

G2 contains the 'crossover value' of interest

Formulas:

H2:

=INDEX(A2:A5,MATCH(TRUE,COUNTIF(OFFSET(B2:E5,ROW(B 2:E5)-ROW(B2),0,1),G2)
0,0))

....confirmed with CONTROL+SHIFT+ENTER

I2:

=INDEX(B1:E1,MATCH(G2,INDEX(B2:E5,MATCH(TRUE,COUNT IF(OFFSET(B2:E5,ROW(B2:
E5)-ROW(B2),0,1),G2)0,0),0),0))

....confirmed with CONTROL+SHIFT+ENTER

Hope this helps!

In article ,
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