Excel index Formula for finding row header value

enter image description here

Refer the attached image, i have table and the column header value in C10 and datas in C11, data value shall be near match should be not less than, with this i want to find the row header value (ie, A,B,C,D,E)

I could not get required result with the below index match formula –

=INDEX(A2:A6,MATCH(C11,INDEX(B2:H6,match(C10,B1:H1,0),),-1))

Thanks in advance

>Solution :

Try using the following formula:

enter image description here

• Formula used in cell C13

=INDEX($A$2:$A$6,MATCH(1,1/(INDEX(B2:H6,,MATCH(C10,B1:H1,0))>=C11),0))

Leave a Reply