INDEX with MATCH
ExpertExpert
14 questions, about 23 minutes
The flexible lookup that works in every version of Excel, in any direction.
What we'll do
- Finding a position with MATCH
- Reading a value with INDEX
- Combining the two
What you'll use
MATCHINDEXMAXMINHLOOKUP
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
14questionsYou do it yourself