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))
```

`=INDEX(A2:C13,MATCH(D1&E1,A2:A13&B2:B13,1),3)`

. It worked. However, it took me a minute to realize that I had mistakenly entered`67`

as the value instead of`67%`

. That gave me the wrong answer but not a #VALUE! error. But the formula above should give you a working starting point. – fixer1234 Sep 26 '17 at 20:22