Excel Study · Module 6: Lookups
Class 50HLOOKUP
Intermediate1:28 videoFree
When a table runs across — months along the top, figures in the rows below — HLOOKUP finds the column whose top cell matches, then returns the value from the row number you give, counting from the top of the table.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B1:F1 has month names, B2:F2 the sales and B3:F3 the orders. B5 has a month name. Write a formula for B7 that returns the orders for that month, using HLOOKUP.
The answer that works
✓ checked in Excel=HLOOKUP(B5,B1:F3,3,FALSE)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.