Excel Study · Module 6: Lookups
Class 51INDEX
Intermediate1:48 videoFree
INDEX returns the item at a position in a range: =INDEX(A2:A8, D2) gives the product at the position in D2. Positions count from the top of the range, not the sheet, so position 3 is row 4 here.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2:A8 has a list of products. Write a formula for D5 that returns the 3rd product in the list, using INDEX.
The answer that works
✓ checked in Excel=INDEX(A2:A8,3)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.