Looking up with VLOOKUP
IntermediateBeginner
15 questions, about 22 minutes
Fetch the right value from a table, based on a code or name.
What we'll do
- The four arguments
- Exact matches with FALSE
- Counting the column number correctly
What you'll use
VLOOKUPIFERROR
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
15questionsYou do it yourself