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 –
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: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 –
Find more great free tutorials at;
Connect with us!
LinkedIn ►
Facebook ►
Twitter ►
Nguồn: https://phanrangninhthuan.info/
Xem thêm bài viết khác: https://phanrangninhthuan.info/tong-hop/
Xem thêm Bài Viết:
- Các Địa Điểm Ưa Thích Nên Đến Tại Ninh Thuận
- Các hàm Excel thông dụng: IF, CountIF, SumIF, CountIFs, SumIFs (hay nhất)
- Giải mã giấc Mơ thấy răng | Nằm Mơ Thấy Răng Là Điềm Báo Gì Nên Mừng Hay Lo
- 15 PHIM HAY NHẤT mọi thời đại – TOP phim kinh điển bất hủ NÊN XEM 1 lần trong đời
- In – Photocopy khổ lớn: A0, A1, A2 giá rẻ | IN THIÊN HẰNG
meteora8888
July 3, 2020thanks. nice and simple to understand examples.
Radhakrishnan Radhakrishnan
July 3, 2020Sir i have one doubt
1-apple
1- banna
One common refernce but vlookup only one view 1- apple but i have need two output- apple/banna how
do you do sir
Radhakrishnan Radhakrishnan
July 3, 2020This is very useful
Debbie Fagan
July 3, 2020Hi Great Video (as they all are) but please can you explain why in INDIRECT to reference other worksheets when you wrote the second part of the Indriect after the & you put " in then not again until after the range of cells?? Sorry if I am being thick but I though " " were to refer to text. Thanks
Mekonnen Yohanes
July 3, 2020Thank you!
Mohamed
July 3, 2020the best explanation of indirect fnc . love it. going to watch so many more now <3 !!!
omar bebars
July 3, 2020In this formula =INDIRECT("Sheet"&A1&"!$A$5") , What if I need cell A5 as variable "A5 , A6, A7" from different sheets . What will the formula look like . Thanks in advance
Denin Srmic
July 3, 2020I 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. 👍
Penny Wang
July 3, 2020Thank 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.
tommyishie
July 3, 2020This is the best explanation of the INDIRECT function I have seen. Thank you!
richard mayorga
July 3, 2020Awesome explanation of a far to underused function in excel! Thank you sir.
Mohammed Aldighaithir
July 3, 2020Hello, thank you for the great video and elaborate explanation. I was wondering if you know of a way that can refer to another excel workbook while it is closed without getting the "Ref" answer.
I have many excel files that usually has only a different month name, and i want to pull the data from it just by changing the month name while it is closed. The indirect approach always asks for the file to be open to see the numbers.
an example is, if i have a file called January report, and i want cell B6 from it, then i also want to have B6 from February report.
referring by indirect has worked only when both files are open.
Ahmed Abdul Alim
July 3, 2020Excellent video
Seshagiri Rao Pamuru
July 3, 2020WHEN YOU ENTER SOUTHEMPTON B3 IT SHOWS DIFFERENT TYPE OF 155. HOW IT ENTERED L 155. PLS TELL ME SIR. MAIL ID IS tally1954@gmail.com
damdan akan
July 3, 2020I feel that watching a premier leageu game :))))
Pongpunt Aaron T.
July 3, 2020This tutorial is extremely helpful. Thank you very much.
Emmanuel Enemchukwu
July 3, 2020I'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.
KINGO INFO
July 3, 2020Amazing video l'm LEARN so much
Zakeer Rg
July 3, 2020AMAZING. Both your detailed lecture and your accent. I have become a fan of yours. Can we have your real name please.
Jasvinder Jassel
July 3, 2020Do you have this worksheet for subscribers to download
Mwamba Chilando
July 3, 2020Great video, beautiful learning.
Milburn Grimes
July 3, 2020You fixed the South Aftica reference by surrounding the single quote with double quotes but on on the front of the formula. After the second & you wrote double quotes + single quote. Why didn't you surround the second single quote the same way as the first one?
Rina Samanta
July 3, 2020I want add two more value under Canada, that means Dynamic Name Range and want to get effect on Office.
I have create Dynamic Name Range using OFFSET(), but getting #REF error when I apply it with INDIRECT().
Please….
Poorani Gunasekaren
July 3, 2020sir nice
can you explain pivot table
Paul Nagle
July 3, 2020Very concise and easy to understand, how is your sister lady gaga ?
Hi Year 2050
July 3, 2020thanks you very much
mahendran p
July 3, 2020wonderful explanation about INDIRECT function, especially combining DATA VALIDATION and INDIRECT function was totally awesome…
Sameh Sameh
July 3, 2020Excellent
Peter Compton
July 3, 2020Great 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
I Nengah Sugita
July 3, 2020thank you, it is really helpfull
Asir In Tisar
July 3, 2020Thanks for making such helpful video….
Mahaboob Hossain
July 3, 2020brother it is showing reference but why?????? my formula is correct according to your guide lines for calculation of indirect formula where this is =sum(indirect(my cel no#))—-the answer is showing REF. Can u solve for me or mail me brother or reply me for the solution plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
siva Chandrasekaran
July 3, 2020Thank you. Clear explanation. Amazed by different techniques!!!
Peter Ng'ang'a
July 3, 2020Thank you, Computergaga. Very much appreciated. This Excel world is just becoming very exciting; courtesy persons like you.
E F
July 3, 2020you are making everything so complicated , plus the reference example is not working
mad nor
July 3, 2020awesome!!!
thank you so much mr gaga.
Sizzler Sizzle
July 3, 2020Awesome.
Thanks u very much for such a detail and simple explanation.
Great Work..
mike obasuyi
July 3, 2020Wow. I have struggled with this function in different forms and here you are making me an expert after watching this 👏🏿👏🏿👏🏿👏🏿👏🏿
tubeampsrule1
July 3, 2020In the conditional table array example, how would I rewrite the Formula to find the person with the largest number for the region you specify?
FRANKWHITE1996
July 3, 2020Thanks!
MDE SASF
July 3, 2020Thank 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!
Chelsea C
July 3, 2020great example! can indirect be used in conjunction of SUMIFS ?
MaxDouglas UK
July 3, 2020This is very informative and helpful!