Lookup & Reference

Excel formula for Two-way lookup (row and column)

Find a value at the intersection of a matched row and a matched column.

Copy this formula

=INDEX(B2:E10, MATCH(G1, A2:A10, 0), MATCH(H1, B1:E1, 0))

How the formula works

The first MATCH locates the row (by G1 in column A), the second MATCH locates the column (by H1 in the header row), and INDEX returns the value where they intersect.

Examples

=INDEX(B2:E10, MATCH("East", A2:A10, 0), MATCH("Q2", B1:E1, 0))→8,400

Returns East-region revenue for Q2.

FAQ

Can XLOOKUP do a two-way lookup?

Yes — nest one XLOOKUP inside another: =XLOOKUP(G1, A2:A10, XLOOKUP(H1, B1:E1, B2:E10)).

Related formulas

Look up a value with INDEX/MATCH Look up a value from another sheet

Functions used

INDEX MATCH

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free