View all of our Excel Video Tutorials on our New YouTube Channel HERE.
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
Spreadsheet: Yes
 Download Here: 1
|
|
