INDEX Function in Excel - Complete Guide | 5 Examples

This video is a complete guide to the INDEX function in Excel including five examples. The Excel INDEX function is possibly the best Excel function. This video starts with a basic Excel INDEX function example. It then moves on to show INDEX ad MATCH in Excel and also INDEX formula to return arrays and ranges. Learn ALL the best functions in Excel - https://amzn.to/3Rg87Go Download the sample workbook to play along - https://www.computergaga.com/_excel/files/formulas/index.xlsx Rolling chart for the last 6 months - https://youtu.be/SR_314s8h_M Moving average formula with INDEX function in Excel - https://youtu.be/tCwds64-3iw These are the video timings. 00:00 - Introduction 00:59 - Basic example of the INDEX function in Excel 03:14 - INDEX MATCH in Excel 05:43 - Two-way lookup formula with INDEX MATCH MATCH 08:51 - Get value from the last row 11:11 - Return an array with INDEX in Excel 14:01 - Dynamic name range with the INDEX function