Looking up in a row with HLOOKUP
AdvancedAdvanced
10 questions, about 17 minutes
VLOOKUP on its side: for tables with headings across the top, such as months.
What we'll do
- Searching in the top row
- Counting the row number
What you'll use
HLOOKUPIFERROR
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself