Inside the VLOOKUP function, the column index argument is normally hard-coded as a static number.
This technique allows you to create a dynamic two-way lookup, matching on both rowsandcolumns.
It can also make a VLOOKUP formula more resilient.
(Note: you could use either zero or FALSE forrange_lookupwith the same result).
With these inputs, the formula returns 9,350, the value for Colby in February.
Excel evaluates the formula from the inside out.
This is the value for Colby in February.
Note that the month lookup is now dynamic.
MATCH supports approximate and exact matching, andwildcards(* ?)
