Excel INDEX/MATCH Formula Generator Tool

Excel INDEX/MATCH Formula Generator

The INDEX/MATCH combination is a powerful alternative to VLOOKUP. This tool will help you build the correct formula based on your needs.

Array (The range containing the value you want to return)

Example: A2:D10 or Sheet1!A2:D10

How do you want to look up?

Row Lookup (Most common)

Column Lookup

Lookup Value (What you're searching for)

Example: A2 for cell reference or "John" for text (include quotes)

Lookup Array (Where to search for the lookup value)

Example: A2:A10 for a column or A2:D2 for a row

Match Type