Two way lookup for column title

[ATSJ]

I have a table that looks like the following

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]16[/TD]
[TD]21[/TD]
[TD]55[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Lisa[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I need to be able to do is look for the letter (column title) that corresponds to a score of 55 for Mary.

In other words, search for Mary's scores, find her score of 55 and which letter corresponds to that.

I've tried combinations of index-match and vlookup without any luck so far. Obviously, the most common situation is finding the 55 using the name and column location so I understand that this is a slightly difference use case.

Any help is appreciated.

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H
1		A	B	C	D		Mary
2	John						55	C
3	Mary	16	21	55	32
4	Alex
5	Lisa
End

Cell Formulas
Range	Formula
H2	=INDEX(B1:E1,MATCH(G2,INDEX(B2:E5,MATCH(G1,A2:A5,0),0),0))

 

[Gerald Higgins]

Assumptions - "Mary" is in cell A3, and her "55" is in cell D3.

The selection of Mary is an input in cell G1, and the selection of 55 is an input in cell G2.

=INDEX(B1:E1,MATCH(G2,OFFSET(A1,MATCH(G1,A2:A5,0),1,1,4),0))

 

[ATSJ]

Amazing, thanks so much. Can't thank you enough...

 

[Fluff]

Glad we could help & thanks for the feedback