Microsoft Excel Functions – INDEX and MATCH Online Course
Is this course right for me?
Do you find that the VLOOKUP function is not quite dynamic enough? Do you want to be able to search an entire data table without the need to move look up references to the left hand column of your table? Do you want to be able to search through multiple tables rather than just one? Then INDEX and MATCH might just be what you need.
Training course objectives:
- 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
Versions Available
2010
Related Training Courses in Our Range
The MATCH Function
- MATCH function syntax
The INDEX Function
- INDEX function syntax – array form
- INDEX function syntax – reference form
Creating Look Ups - Using INDEX And MATCH
- Creating dynamic look up functions combining INDEX and MATCH
Return Values From Across Multiple Tables
- Using the REFERENCE form to search multiple tables
- Using drop down lists to create dynamic searches
Using MATCH with VLOOKUP
- Creating a dynamic VLOOKUP formula
