Skip to content

Two-Way Lookup

Published: Oct 19, 2026 | Updated: Oct 19, 2026 | About (Japanese)

Key points

Enter the header range
Enter the header value
Copy it

In INDEX MATCH Builder, entering the header range and value makes a two-way table lookup.

Steps

Enter the header range
Enter the header value
Copy it

Two MATCH functions find the row and the column.

Use "Build an INDEX and MATCH Formula" (free)

Tools that go well with this

Build a VLOOKUP or XLOOKUP Formula: Build VLOOKUP and XLOOKUP formulas.
Build a FILTER Formula: Build a FILTER formula.
Build a SUMIF or COUNTIF Formula: Build SUMIF and COUNTIF formulas.

If this guide helped, a small tip would mean a lot.

Send a tip (¥300)Send a gift (Amazon wishlist)

More guides for this tool