Another way using VLOOKUP(). Make sure the text mentioned in the formula or
reference cell is exactly same as mentioned in row headers and column headers

=VLOOKUP("Loose",A1:E10,MATCH("Exposed",A1:E1,0),0 )

'with the lookup values in F1 and F2
=VLOOKUP(F1,A1:E10,MATCH(F2,A1:E1,0),0)

If this post helps click Yes
---------------
Jacob Skaria


"msao" wrote:

please help with this need to recive the intercection between loose And
exposed answer shold be E.

Shelterd Partially Shelterd Eposed Extremely
Exposed
Very Loose E D C
A
Loose G F E
B
Average J I H
F
Tight K J I
G
Very Tight L L L
L

Thank you for the Help