Forum Discussion
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...
=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.
=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.