Excel Forum



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.