Index Row header

[Rolly_Sefu]

Hello I have a table (my table will never start from A1)

For ex: I have the nr 13 and column name "Sat"

And I need the row header: "Alan"

unfortunately I can not use : =Index(E8:E10,Match(("13",G7:F10,0)) because I get an error.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]E[/TD]
[TD]G[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Alan[/TD]
[TD]20[/TD]
[TD]13[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]James[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Karla[/TD]
[TD]12[/TD]
[TD]15[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

Any ideas for a good and simple formula ?

Thank you

 

[SyedUsman]

=INDEX(E8:E10,MAX(IF(13=F8:H10,ROW(E8:E10)-ROW(E8)+1)))

Use With Ctrl + Shift + Enter

 

[Rolly_Sefu]

Hello.

Works perfectly.

Thank you.