VLOOKUP with an approximate match
AdvancedAdvanced
10 questions, about 18 minutes
Find the group a number falls into, such as a discount band or a grade.
What we'll do
- Approximate matches with TRUE
- Sorting the first column in ascending order
What you'll use
VLOOKUP
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