The INDEX-MATCH combination is an advanced technique that can solve many look up problems. The two functions are useful in their own right, but together they provide a range of solutions to common look up requirements.
In this session you will
- learn the basics of the INDEX function
- see how versatile INDEX can be in solving problems
- learn the basics of the MATCH function
- discover how well they work together to solve look up problems
- find out how they work with formatted tables
- see how to handle errors
- learn how well INDEX works with dynamic arrays
As always, you will discover a few other tips during the session.