Excel Study · Module 6: Lookups
Class 47VLOOKUP: exact match
Intermediate2:04 videoFree
VLOOKUP finds a value in the first column of a table and brings back a value from the same row: =VLOOKUP(E2,A2:C7,3,FALSE) finds the code in E2 among the codes in column A and returns column 3 of the table, the price.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2:C7 is a product list: codes in column A, product names in column B, prices in column C. E2 has a product code. Using VLOOKUP, write a formula for F3 that gives the price of that code.
The answer that works
✓ checked in Excel=VLOOKUP(E2, A2:C7, 3, FALSE)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.