Lookup
Two-Way Lookup (INDEX MATCH MATCH)
Find a value at the intersection of a specific row and column. Like looking up a value in a multiplication table — you specify the row header and column header.
Excel Formula
=INDEX(B2:F10, MATCH(H2,A2:A10,0), MATCH(I2,B1:F1,0))Step-by-Step Explanation
1
INDEX returns a value from a specific row and column in a range
2
First MATCH finds the row position by matching H2 in A2:A10
3
Second MATCH finds the column position by matching I2 in B1:F1
4
Combined, they pinpoint the exact cell at the intersection
5
Perfect for lookup tables, schedules, and cross-reference matrices
Example
| Q1 | Q2 | Q3 | Q4 | |
|---|---|---|---|---|
| North | $10K | $12K | $15K | $11K |
| South | $8K | $9K | $11K | $10K |
| East | $14K | $16K | $18K | $15K |
Result: =INDEX(B2:E4,MATCH("South",A2:A4,0),MATCH("Q3",B1:E1,0)) → $11K
Common Variations
XLOOKUP nested
=XLOOKUP(H2,A2:A10,XLOOKUP(I2,B1:F1,B2:F10))Excel 365 modern approach
With error handling
=IFERROR(INDEX(B2:F10,MATCH(H2,A2:A10,0),MATCH(I2,B1:F1,0)),"Not Found")Returns 'Not Found' instead of error
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →