Finding the correct row reference

[Jamie Wagler]

Please refer to the attached file.

I am looking for a way to "find" C (in red) with only knowing Column 3 and Row K (in green).

A way to count rows until I find K might work?

 

[Luke M]

given this layout:


Formula would be:
=INDEX(C2:G27,MATCH(K2,A2:A27,0),K1)