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.

	E	G	E	F
7		Fri	Sat	Sun
8	Alan	20	13	4
9	James	7	5	9
10	Karla	12	15	10

<tbody>
</tbody>

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.