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/f...

Rolling chart for the last 6 months - Create Dynamic Rolling Chart to Show ...
Moving average formula with INDEX function in Excel - Moving Average in Excel (Seven-Day Ro...

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

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► LinkedIn: 18737946
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1

• #howto_style
• #index_function_in_excel
• #excel_index_function
• #best_excel_function
• #index_match
• #index_and_match
• #excel_match_function
• #index_and_match_function_in_excel
• #index_and_match_in_excel
• #excel_index_function_dynamic_range
• #computergaga
• #excel_formulas
• #excel_index_formula
• #excel_for_analysts
• #index_formula
• #index_match_in_excel
• #index_function
• #index_formula_in_excel
• #excel_advanced_formulas
• #advanced_excel_tricks