Forum Discussion
sdwkelly
Mar 23, 2022Copper Contributor
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...
JMB17
Mar 23, 2022Bronze Contributor
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]))