Forum Discussion

Copper Contributor

Sep 12, 2022

Solved

INDEX MATCH BETWEEN 2 PERCENTAGE in the same columns

greetings sorry for my English i would like to have a best function for below image i want a formula to get the right value based on B15 and C15 input the percentage is between column 1...

excel

OliverScheurich
Sep 12, 2022
zeyad_halawanai
=INDEX(B3:G9,MATCH(B15,A3:A9,0),MATCH(1,(C15>=B2:F2)*(C15<=B1:F1),0))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

zeyad_halawanai

Copper Contributor

Sep 12, 2022

i tried it and i got same answer #N/A

mtarler

Silver Contributor

Sep 12, 2022

not sure why, that is exactly how it should work. I would need to see your actual sheet to see why.
on another note: G1 should be 50 not blank and G2 should be 0 for any formula to work right on values <=50

mtarler
Silver Contributor
Sep 12, 2022
oh I just looked at your formula again and think you might have confused my answer. The formula should be simply:
=INDEX(B3:G9,MATCH(B15,A3:A9,0),MATCH(C15,B1:G1,-1))