My data is here:
I am writing an array index match with 2 criteria, where I want to return the value in column 3 if my first data matches the Column 1 and is greater than or equal to value in Column 2.
For example, if my array is A and 67, then I want to have the formula return with the value in Column 3 that is equal to 9%.
I tried the following but I get a #VALUE! error:
=index(table1[column3], match(D1&E1, table1[column1]&table1[column2], -1))