Lookup header based on name

[luna023]

Hello, Please help me find a formula for this problem I couldn't think straight.

I need to get the header title/the levels using the names. I hope you guys could help me thanks.

Please see image below.

 

[Michael M]

This should work....modified from Aladin Akyurek

=INDEX($A$1:$E$1,SUMPRODUCT(MAX(($A$2:$E$5=A14)*(COLUMN($A$2:$E$5))))-COLUMN($A$1)+1)

 

[luna023]

Thank you! this helped a lot!

 

[bosco_yip]

Or,

In B15, copied down :

=INDEX($A$1:$E$1,SUMPRODUCT(($A$2:$E$9=A15)*COLUMN($A$1:$E$1)))

Regards
Bosco