NEW! Microsoft Excel Functions – INDEX And MATCH Online Course

Find out more about our Online Training Courses

Is it 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.

What will I get out of it?

By the end of the course you will know:

• 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

Related courses in our range

• Microsoft Excel Look Up Functions - LOOKUP, VLOOKUP, HLOOKUP Online Course
• Microsoft Excel – Excel Data Validation Online Course
• Microsoft Excel – Excel Pivot Tables Online Course

What does it cover?

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

• Create dynamic look up functions combining INDEX and MATCH

Return Values From Across Multiple Tables

• Use the REFERENCE form to search multiple tables
• Use drop down lists to create dynamic searches

Using MATCH with VLOOKUP

• Create a dynamic VLOOKUP formula