Forum Discussion

sdwkelly's avatar
sdwkelly
Copper Contributor
Mar 23, 2022

Using Index Match -1 Match Type when matching 2 values

Hello,   I am trying to use index match as an array where I take into account 2 values in my match statement to determine which value to pull. However, I want my match type to be -1 for both. My ex...
excel
JMB17's avatar
JMB17
Bronze Contributor
Mar 23, 2022

sdwkelly 

 

Where E1 is the percentage you're trying to find and F1 is the value, you could try:

 

=IFERROR(INDEX(Table2[Type], MATCH(1,(Table2[Percentage]=E1)*(Table2[Value]=F1), 0)), LOOKUP(2, 1/(Table2[Percentage]<=E1)/(Table2[Value]<=F1), Table2[Type]))

Resources