How to Use the INDEX and MATCH Function in Excel

INDEX and MATCH are Excel functions that are closely related. You can nest MATCH within INDEX to perform more advanced lookups. Here's how it works.

April 15, 2025 · 1 min · 72 words · Jenna Morton

Table of Contents

What Are the INDEX and MATCH Functions?

INDEX and MATCH are Excel lookupfunctions.

The INDEX function returns a value or the reference to a value from within a particular selection.

INDEX MATCH Excel function example

The goal is to identify the item color using the item number.

The idea is to see how much money we made off ofGreenitems inMay.

This is really similar to the example above, but an extra MATCH formula is nested in INDEX.

INDEX Excel formula examples

MATCH function examples in Excel

MATCH and INDEX Excel functions nested in one formula

INDEX and MATCH nesting example in Excel