Learn the INDIRECT function of Excel with these 5 INDIRECT function examples.

See how to use INDIRECT with named ranges, to reference other worksheets, create R1C1 references and see it used with other functions.

Download the file to follow along here – https://www.computergaga.com/_excel/files/indirect-examples.xlsx

Learn 150 of the best Excel functions https://amzn.to/3Rg87Go
More than 500 formula examples.

The INDIRECT function is one of the most misunderstood of the functions of Excel. It can be really powerful when used correctly. These 5 examples will show you different reasons as to why INDIRECT is thought of so highly.

Below are the timings for the different tutorials in this video.

00:00 – Introduction
00:38 – INDIRECT with Named Ranges
03:26 – INDIRECT to reference other worksheets
07:52 – Using R1C1 referencing with INDIRECT to return the last value in a row
12:15 – INDIRECT with VLOOKUP
14:40 – Dependent Drop Down Lists

Got any questions. Please post them in the comments area.

Master Excel today with this comprehensive course – https://bit.ly/UltimateExcel

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 ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.