Excel Study · Module 6: Lookups
Class 52MATCH
Intermediate1:45 videoFree
MATCH tells you WHERE an item is: =MATCH(D2, A2:A8, 0) returns the position of the name in D2 in the list. The 0 asks for an exact match, and the list can be in any order.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2:A8 has staff names. Write a formula for D5 that returns the position of the name Mei in the list, using MATCH with an exact match.
The answer that works
✓ checked in Excel=MATCH("Mei",A2:A8,0)AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.