While the VLOOKUP function in Microsoft Excel is an extremely useful tool, there are certain situations in which it’s not quite dynamic enough – for example, when you want to be able to search an entire data table without the need to move lookup references, or you want to be able to search through multiple tables at once. In those instances, the INDEX or MATCH functions can solve your problem.
We take an in-depth look at both the INDEX and MATCH functions – what they do, how they work, and how they can be used in conjunction with the VLOOKUP function. Learners are encouraged to participate in the session by asking questions, and we’ll be here to give you support via telephone, email or Twitter for 90 days after the programme finishes.
Is it right for me?
What will I get out of it?
By the end of the course you will be able to:
- The syntax to the INDEX and MATCH functions
- How to combine INDEX and MATCH to create fully dynamic searches
- How to search across multiple areas or tables
- How to display user tips
- How to warn or prevent users from entering invalid data