5 Excel INDIRECT Function Examples - Learn the Great INDIRECT Function
Тәжірибелік нұсқаулар және стиль
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 - www.computergaga.com/_excel/f...
Learn 150 of the best Excel functions 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 - bit.ly/UltimateExcel
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
Пікірлер: 436
This is the best explanation of the INDIRECT function I have seen. Thank you!
@Computergaga
4 жыл бұрын
Thank you very much. Your comment is much appreciated.
Been searching for some time to find a solution to shorten my otherwise would-be long formula and this (last part) was just what I needed! Thank you very much for taking the time to share your experience, it's much appreciated!
Thank you for stepping through the Indirect formula. I've seen it a dozen times on as many sites, but I have not seen one explanation of each component of the formula. Much appreciated! Thank you!
@Computergaga
5 жыл бұрын
You're very welcome 👍
Thanks for the feedback. I did try to use "R10C4" and it works but only for that column and not for the next/expanding columns. So ur right it does make sense to use COUNTA. Thanks again.
I don't often leave comments but this was so well done that I felt compelled. Kudos for clear concise explanations but my favorite part was the multiple examples that demonstrate real world challenges and the slightly different approaches you might need to take to solve them. Take a bow sir!
@Computergaga
6 жыл бұрын
Thank you very much for those lovely comments Scott.
An analyst at work used this a few years back for a spreadsheet I use daily, I always wondered over it, now finally taking the time to understand it. Thank you for this vid!!!
@Computergaga
6 жыл бұрын
My pleasure Cipher-Tu Productions.
Great video. I've seen many explanations for INDIRECT() and this is by far the best, especially the one referring to other sheets with spaces in the sheet name. Thanks very much
@Computergaga
5 жыл бұрын
You're very welcome Peter. Thank you.
Thank you, Thank you, Thank you, Thank you, Thank you so much. You have no idea how useful this is to me in my daily work. Thank you ever so much. Kindly continue to contribute such excellent tutorials with excellent examples. God Bless You.
@Computergaga
7 жыл бұрын
Thanks Biju, your welcome.
Good examples and good explanations for indirect functions! You put in learners' shoes and lead us to see how indirect function helps us. Thank you!
@Computergaga
3 жыл бұрын
You're welcome. Thank you.
Great examples Alan! This is the best demonstration of indirect function, so easy to understand, clear and how it can be used in so many ways which I hadn't known before. Now I know why indirect() is useful which I failed to gather from other channels. To add to the complexity of the last example, it would be great to show how to handle an office that consists of two words like Milton Keynes. :)
@Computergaga
6 жыл бұрын
Thank you Lena. I have a video on solving this situation. You can find it here - kzread.info/dash/bejne/k52YsbmIo7DKdJs.html
This is great! I had to populate data from several other tabs in a different file. You just made me look like a genius at work!
@Computergaga
5 жыл бұрын
That is great Jason. You are a genius :)
Thank you, Computergaga. Very much appreciated. This Excel world is just becoming very exciting; courtesy persons like you.
@Computergaga
5 жыл бұрын
Welcome. There is no getting off the Excel world. It rotates too fast. You are here to stay 😂
Thank you for an effective lesson on the INDIRECT function!
@Computergaga
6 жыл бұрын
You're welcome K, thank you.
There must be a good reason why I easily understand what you explain than many other people who offer different tutorials. The reason is simply, you can explain things so well. THANKS INDEED.
@Computergaga
5 жыл бұрын
You're very welcome. Thank you for your kind words Salim.
OMG, this is AMAZING! and so useful. Also well explained and demonstrated - subed
@Computergaga
6 жыл бұрын
Thank you Tomasz.
Loved it Alan, thank you for the great explanation of the indirect function. Cheers Mohideen
@Computergaga
7 жыл бұрын
Thanks Mohideen
I'm 8 minutes in and I already came here to drop a comment on how amazing this explanation is. Also thanks for a little British humor.
@Computergaga
4 жыл бұрын
Thank you Emmanuel. Your comment is appreciated.
Thank you very much. Very interesting, practical, inspiring, revealing and thought provoking. You are doing a great job for the excel lovers/addicts/users. Please continue your good job for the benefit of Excel users with some more tricks/tips/time saving tools. Yours affectionate.
@Computergaga
7 жыл бұрын
You can guarantee more tricks/tips and time saving tools Gopala my friend.
AMAZING. Both your detailed lecture and your accent. I have become a fan of yours. Can we have your real name please.
@Computergaga
4 жыл бұрын
Thank you Zakeer. My name is Alan Murray.
@anonymous_553
Жыл бұрын
@@Computergaga I'm having trouble understanding and making use of the following formula =if(not(isblank(B31)), indirect("Income!D"&B31&":Q"&B31)," "). I'm a beginner, can you help please?
Excellent!
@Computergaga
7 жыл бұрын
Thanks Dinesh.
Thank you ! I've been sufferred from learning “INDIRECT" as it's not as clear logic as other fuctions. Watched around 3-4 videos still couldn't get until I watched your video. Now it's crystal clear and now I'm confident to use "INDIRECT" in work.
@Computergaga
4 жыл бұрын
Great to hear! Thank you Penny.
computergaga always comes with inspirational videos
I had seen many videos on Indirect function and this actually is the best.Thank you
@Computergaga
5 жыл бұрын
Excellent! Great to hear Arun. Thank you.
An interesting demonstration, and very useful information. Thank you!
@Computergaga
5 жыл бұрын
You are very welcome.
Amazing, I learned indirect with this short video. thank you !
@Computergaga
7 жыл бұрын
Your welcome Ben.
the best explanation of indirect fnc . love it. going to watch so many more now
@Computergaga
4 жыл бұрын
Awesome, thank you Mohamed.
Wow. I have struggled with this function in different forms and here you are making me an expert after watching this 👏🏿👏🏿👏🏿👏🏿👏🏿
@Computergaga
5 жыл бұрын
Excellent! Nice one Mike.
Well done - clearest examples yet I have seen on the 'INDIRECT' function. Many Thanks !!!
@Computergaga
3 жыл бұрын
Thank you very much, Kirk.
Excellent explaination to make use of indirect function.
@Computergaga
5 жыл бұрын
Thank you Alok.
Spent 3 hours trying to figure out the error with the spaces that causes #REF and this is the only explanation that helped. Thank you so much!
@Computergaga
Жыл бұрын
You're very welcome.
Insightful lecture on the Indirect function! Awesome
@Computergaga
6 жыл бұрын
Thanks Viktor.
Thanks for making and sharing this excellent video. I appreciate your intelligent work.
@Computergaga
5 жыл бұрын
You're welcome Nishant.
Hello Mr. Alan; Superb video, thank you, I liked your explanation and your lesson of INDIRECT function: you helped me to retain this function and especially liaisin with another sheet with a name composed as "South Africa" thanks again
@Computergaga
6 жыл бұрын
You're welcome Abu. I am glad I was able to help.
This is a masterpiece, Sir!..... Agreed you have taught the world of this most useful function called , INDIRECT, I learnt in a very simple way, you voice is clear and audible plus has a very good command on the language plus the enthusiasm throughout the video was overwhelming.. Sir! Thanks a ton.... From India
@Computergaga
6 жыл бұрын
Your welcome Avinash, thank you very much.
Sir, This is one of the most INFORMATIVE video on INDIRECT function. This is so useful making life of finance person like me a dam easy.. just amazing.. thanks for sharing...
@Computergaga
7 жыл бұрын
Your welcome Sachin, thank you.
Maybe the best explanation of indirect on KZread. Thank you!
@Computergaga
3 жыл бұрын
That's awesome! Thank you very much, Cary.
Now I know how to use the various indirect functions. You explained it so well, thank you.
@Computergaga
3 жыл бұрын
You're welcome, Juanita. Thank you.
This tutorial is extremely helpful. Thank you very much.
@Computergaga
4 жыл бұрын
Great to hear. Thank you.
Extremely well explained!
@Computergaga
6 жыл бұрын
Thank you Excel Rush.
Great! useful in many occasions. Thank you
@Computergaga
5 жыл бұрын
My pleasure Samuel.
So today i got to look at INDIRECT + R1C1 + COUNTA. That was really good. Never seen all that being used at one go. Very interesting if u need to fetch the LAST VALUE for anything. Thank u very much for sharing.
@Computergaga
7 жыл бұрын
Your welcome James
You deserve alot more likes for this well explained video.
@Computergaga
6 жыл бұрын
Thank you Keval.
@lisamccray6481
4 жыл бұрын
@11:13+, you said A1 or C1 or (R1?) style reference. I'm not sure what that means but OK. It obviously is a column, OR row, OR all of the table thing. It feels like I am missing the point by just a small detail.
Good piece of work that’s well explained. Thanks
@Computergaga
5 жыл бұрын
Thank you Noel.
Awesome. Thanks u very much for such a detail and simple explanation. Great Work..
@Computergaga
5 жыл бұрын
Thank you. My pleasure.
Absolutely brilliant! Cheers!
@Computergaga
6 жыл бұрын
You're welcome Sergio.
Excelente explanation, thanks so much.
@Computergaga
5 жыл бұрын
Thank you.
wonderful explanation about INDIRECT function, especially combining DATA VALIDATION and INDIRECT function was totally awesome...
@Computergaga
5 жыл бұрын
Thank you Mahendran.
This is very informative and helpful!
@Computergaga
5 жыл бұрын
Thank you.
Awesome explanation of a far to underused function in excel! Thank you sir.
@Computergaga
4 жыл бұрын
Glad you liked it Richard. Thank you for your comments.
Thank you. Clear explanation. Amazed by different techniques!!!
@Computergaga
5 жыл бұрын
Thank you Siva.
@sivamagesh
5 жыл бұрын
@@Computergaga you are welcome
THIS IS THE BEST DISCUSSION OF INDIRECT FUNCTION! THANK YOU SO MUCH
@Computergaga
2 жыл бұрын
Thank you.
Awesome! Its explained in such a brilliant way! All thumbs up!
@Computergaga
4 жыл бұрын
Thank you, Yeasir.
Thanks a lot. The examples which were showcased are quite realistic.
@Computergaga
Жыл бұрын
You're welcome. Thank you for your comment.
And finally the magic of INDIRECT + NAMED RANGES/Dependent Lists. I liked 4/5 of the INDIRECT function examples. Thank u for sharing.
Simple and clear, thank you. keep the good work
@Computergaga
3 жыл бұрын
Thank you very much, Sumudu.
Excellent. Best video on indirect funtion on KZread.
@Computergaga
2 жыл бұрын
Thank you very much.
Sir, This is one of best videos very easy way to describe thx
@Computergaga
5 жыл бұрын
Thank you very much.
Thank you so much for the insight in INDIRECT! I will definitively use it mor often :)
@Computergaga
10 ай бұрын
You're so welcome! Thank you.
You were of great help. Very clear explanation! Thank you :)
@Computergaga
3 жыл бұрын
Glad to hear that! Thank you, Ishaan.
awesome!!! thank you so much mr gaga.
@Computergaga
5 жыл бұрын
You're very welcome.
Hi Alan.. another excellent tutorial. I've never really done much with INDIRECT(). Like many people, I went along for many years thinking I knew EXCEL well. Your great videos show me all the things I've been missing. I'll definitely incorporate INDIRECT() into future projects, although I understand that as a volatile function, using INDIRECT() sparingly is advised. I particularly like its use for dependent drop downs.. very clever. Thanks for helping me build a more solid foundation of EXCEL skills which I can use in my business and life. Thumbs up!
@Computergaga
6 жыл бұрын
Thank you Wayne. Yes it is a very helpful function. Quite right in that it is a volatile function. So should be aware of such things when working with large workbooks as it can slow calculation speed.
Wow! Thank you for the amazing explanation, I finally got it 😃
@Computergaga
3 жыл бұрын
Awesome! My pleasure, Maryna.
Great video thank you I found it helpful!
@Computergaga
6 жыл бұрын
You're welcome, thank you.
I was really not that versed in using =INDIRECT(function) and to be frank I was avoiding to use it. But after well expounded topic in this tutorial it makes a lot of sense what is used for and especially when it comes using it with named ranges. Thank you for explaining in minute detail and to the point for all of us. 👍
@Computergaga
4 жыл бұрын
You're very welcome, Denin. Thank you for the comments.
Went through many videos to land at this conclusive & the best video on INDIRECT ...thank u
@Computergaga
4 ай бұрын
Thank you very much 🙂 Glad it was useful.
thanks sir I had demanded u have completed extremely wonderful
@Computergaga
7 жыл бұрын
Not a problem Jacky. I promised you something on INDIRECT :)
Good work. Very useful. Thanks for your efforts
@Computergaga
5 жыл бұрын
You're welcome Balasubramanian. Thank you.
thanks. nice and simple to understand examples.
@Computergaga
4 жыл бұрын
You are welcome! Thank you.
Was struggling to get this to work from the other videos I've watched, but the bit at 5:30 was exactly what I needed :D
@Computergaga
Жыл бұрын
Excellent! Very happy to have helped.
Really helpful for me.thanks a lot sir
@Computergaga
6 жыл бұрын
Great to hear Sabbasachi.
Thats wonderful !!! Thanks again
@Computergaga
5 жыл бұрын
My pleasure Murthy.
Once again, here is the biggest LIKE I have ever given. Thank you.
@Computergaga
5 жыл бұрын
Thank you very much Salim.
Echoing other comments - this is fantastic explanation. Can't wait to use this function.
@Computergaga
2 жыл бұрын
Thank you, George.
Reeeeeeally well explained. Thank you so much!
@Computergaga
Жыл бұрын
You're very welcome. Thank you.
Excellent video
@Computergaga
7 жыл бұрын
Thanks Amit
Great video, beautiful learning.
@Computergaga
4 жыл бұрын
Thank you Mwamba.
Awesome tutorial! Brilliant!
@Computergaga
2 ай бұрын
Thank you very much.
Thank you. Clear explanation.
@Computergaga
3 жыл бұрын
Great. You're welcome, Mirriam.
Excellent! It helped me a lot. Thanks!
@Computergaga
4 ай бұрын
Super! Thank you very much 🙂
Excellent tutorial!
@Computergaga
5 жыл бұрын
Thank you Yacha.
Your lessons so good.
@Computergaga
2 жыл бұрын
Thank you 😊
Worthy fully watching Sir
@Computergaga
6 жыл бұрын
Thanks Obaid.
Great way to teach. Thanks
@Computergaga
6 жыл бұрын
Thank you Bharat.
well appreciated Alan. well explained. Thanks
@Computergaga
Жыл бұрын
Thank you 😊
Super examples! Excellent
@Computergaga
5 жыл бұрын
Thank you bhavitraja.
Awesome function and wonderful explanation.
@Computergaga
3 жыл бұрын
Thank you, Abhishek.
Thank You. I am beginner but I am learning. THANKS A LOT.
@Computergaga
7 жыл бұрын
Your welcome Matt, thanks.
This tutorial is Amazing! Thank you. In the first worksheet 'with named ranges'; when I change the formula from SUM to AVERAGE, keep the rest same, the result i get is 523 instead of 588, which happens to be the correct answer. Please help understand this. Thank you
Thanks for making such helpful video....
@Computergaga
5 жыл бұрын
You're welcome Asir.
Great video, thank you.
@Computergaga
6 жыл бұрын
You're welcome captainvlog.
Awesome!! Like your channel!
@Computergaga
5 жыл бұрын
Thank you Nephilibata.
Hello Sir Computergaga, How are you? Happy New Year. I found this video and was extremely excited to learn the format(s) that you shared. I do have a query if during the month and or week, I transfer money from checking to savings and or received refunds from purchases, can you share how the formula can be modified to do so? I really appreciate and look forward to seeing that video. Sincerely New Viewer
thank you, it is really helpfull
@Computergaga
5 жыл бұрын
Excellent! You're welcome.
What a teacher!
@Computergaga
2 жыл бұрын
Thank you 😊
Thank you very helpful and a very good explanation
@Computergaga
Жыл бұрын
Thank you very much.
Fantastic Many thanks
@Computergaga
7 жыл бұрын
Your welcome Mahmoud
Brilliant, thanks a million
@Computergaga
9 ай бұрын
You're very welcome 👍
Great vid. Thank you.
@Computergaga
5 жыл бұрын
Thank you Liz.
Thanks for sharing!
@Computergaga
2 жыл бұрын
You're welcome, Robson.
Thank you for the amazing video....
@Computergaga
3 жыл бұрын
You're welcome 👍 Thanks