Home » Posts

Join tables with INDEX and MATCH

To join or merge tables that have a common id, you can use the INDEX and MATCH functions. In the example shown, the formula in E5 is: =INDEX(data,MATCH($C5,ids,0),2) where "data" is the named range H5:J8 and "ids" is the named range H5:H8.

April 14, 2025 · 1 min · 57 words · Derek Gonzalez

Table of Contents

Explanation

This formula pulls the customer name and state from the customer table into the order table.

Retrieving customer state

The formula to retrieve customer state is almost identical.

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

Excel formula: Merge tables with VLOOKUP

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

Often, MATCH is combined with the…

Excel formula: INDEX and MATCH exact match

Excel formula: Two-way lookup with INDEX and MATCH

Excel INDEX function

Excel MATCH function

Explanation#

Retrieving customer state#

Explanation

Retrieving customer state