Excel Study · Module 6: Lookups
Class 53INDEX + MATCH together
Intermediate1:40 videoFree
VLOOKUP can only return a value to the right of the column it searches. When the code is in column C and the product name is to its left in column A, put MATCH inside INDEX: MATCH finds the position of the code, INDEX returns the name in that position.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2:A6 has product names, B2:B6 prices and C2:C6 product codes. B8 has a code. Write a formula for B10 that returns the product name for that code, using INDEX and MATCH.
The answer that works
✓ checked in Excel=INDEX(A2:A6, MATCH(B8, C2:C6, 0))
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.