Free INDEX & MATCH Generator

A more flexible alternative to VLOOKUP. Returns the value of an element in a table or an array, selected by the row and column number indexes.

Column to Return Value From

Value to Look For

Column to Search In

Match Type

Generated Formula

=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

Want to master Excel? Check out this Top-Rated Course.

Stop searching for formulas. Master Excel in 30 days with this top-rated course.