Home » Posts

INDEX with variable array

To set up an INDEX and MATCH formula where the array provided to INDEX is variable, you can use the CHOOSE function. In the example shown, the formula in I5, copied down, is: =INDEX(CHOOSE(H5,Table1,Table2),MATCH(G5,Table1[Model],0),2) With Table1 and Table2 as indicated in the screenshot.

April 14, 2025 · 1 min · 43 words · Bethany Clark

The value can be a constant, a cell reference, anarray, or a range.

you’re able to use INDEX to retrieve individual values, or entire rows and columns.

MATCH supports approximate and exact matching, andwildcards(* ?)

Excel formula: INDEX and MATCH exact match