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 –


Thanks in advance

>Solution :

Try using the following formula:

enter image description here

• Formula used in cell C13


Leave a Reply