Looking up with XLOOKUP
AdvancedAdvanced
12 questions, about 19 minutes
The modern successor: it searches in any direction and looks for an exact match by default.
What we'll do
- Choosing the lookup column and the return column
- Looking to the left
- Your own message when nothing is found
What you'll use
XLOOKUPINDEXMATCHMAX
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
12questionsYou do it yourself