Excel Study · Module 6: Lookups
Class 54Two-way lookup
Advanced1:43 videoFree
A two-way lookup finds a value by its row name AND its column name: the sales of one branch in one month.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B2:E5 has sales, with branch names in A2:A5 and month names in B1:E1. B7 has a branch and B8 a month. Write one formula for D9 that returns the sales for that branch and month, using INDEX and MATCH.
The answer that works
✓ checked in Excel=INDEX(B2:E5, MATCH(B7, A2:A5, 0), MATCH(B8, B1:E1, 0))
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.