Two way lookup for column title

[ATSJ]

I have a table that looks like the following

	A	B	C	D
John
Mary	16	21	55	32
Alex
Lisa

<tbody>
</tbody>

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