Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Lookups With MATCH() and INDEX() Functions

This video tutorial will show you how to use the MATCH() and INDEX() functions within excel. These are useful functions to lookup data in excel and are often used together. The match function works well when nested inside and index formula; when alone, the match function is not as useful. Together, they will return a relative cell reference and also the contents of a cell located through a relative cell reference.

These are two functions which allow you to create robust lookup formulas within excel, especially when the VLOOKUP() and HLOOKUP() functions will not work.
   Topics Covered
MATCH() Function
INDEX() Function
Nesting MATCH() and INDEX() Functions
Doing Lookups with the MATCH() and INDEX() Functions
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.