5 Excel INDIRECT Function Examples – Learn the Fantastic 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 –

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://mechoimages.com/

Xem thêm bài viết khác: https://mechoimages.com/tong-hop/


Article Categories:
Tổng Hợp

Comments

  • Hi 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

    Debbie Fagan June 20, 2020 2:09 pm Reply
  • Thank you!

    Mekonnen Yohanes June 20, 2020 2:09 pm Reply
  • the best explanation of indirect fnc . love it. going to watch so many more now <3 !!!

    Mohamed June 20, 2020 2:09 pm Reply
  • In 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

    omar bebars June 20, 2020 2:09 pm Reply
  • 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. 👍

    Denin Srmic June 20, 2020 2:09 pm Reply
  • 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.

    Penny Wang June 20, 2020 2:09 pm Reply
  • This is the best explanation of the INDIRECT function I have seen. Thank you!

    tommyishie June 20, 2020 2:09 pm Reply
  • Awesome explanation of a far to underused function in excel! Thank you sir.

    richard mayorga June 20, 2020 2:09 pm Reply
  • Hello, 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.

    Mohammed Aldighaithir June 20, 2020 2:09 pm Reply
  • Excellent video

    Ahmed Abdul Alim June 20, 2020 2:09 pm Reply
  • WHEN 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

    Seshagiri Rao Pamuru June 20, 2020 2:09 pm Reply
  • I feel that watching a premier leageu game :))))

    damdan akan June 20, 2020 2:09 pm Reply
  • This tutorial is extremely helpful. Thank you very much.

    Pongpunt Aaron T. June 20, 2020 2:09 pm Reply
  • 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.

    Emmanuel Enemchukwu June 20, 2020 2:09 pm Reply
  • Amazing video l'm LEARN so much

    KINGO INFO June 20, 2020 2:09 pm Reply
  • AMAZING. Both your detailed lecture and your accent. I have become a fan of yours. Can we have your real name please.

    Zakeer Rg June 20, 2020 2:09 pm Reply
  • Do you have this worksheet for subscribers to download

    Jasvinder Jassel June 20, 2020 2:09 pm Reply
  • Great video, beautiful learning.

    Mwamba Chilando June 20, 2020 2:09 pm Reply
  • You 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?

    Milburn Grimes June 20, 2020 2:09 pm Reply
  • I 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….

    Rina Samanta June 20, 2020 2:09 pm Reply
  • sir nice
    can you explain pivot table

    Poorani Gunasekaren June 20, 2020 2:09 pm Reply
  • Very concise and easy to understand, how is your sister lady gaga ?

    Paul Nagle June 20, 2020 2:09 pm Reply
  • thanks you very much

    Hi Year 2050 June 20, 2020 2:09 pm Reply
  • wonderful explanation about INDIRECT function, especially combining DATA VALIDATION and INDIRECT function was totally awesome…

    mahendran p June 20, 2020 2:09 pm Reply
  • Excellent

    Sameh Sameh June 20, 2020 2:09 pm Reply
  • 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

    Peter Compton June 20, 2020 2:09 pm Reply
  • thank you, it is really helpfull

    I Nengah Sugita June 20, 2020 2:09 pm Reply
  • Thanks for making such helpful video….

    Asir In Tisar June 20, 2020 2:09 pm Reply
  • brother 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

    Mahaboob Hossain June 20, 2020 2:09 pm Reply
  • Thank you. Clear explanation. Amazed by different techniques!!!

    siva Chandrasekaran June 20, 2020 2:09 pm Reply
  • Thank you, Computergaga. Very much appreciated. This Excel world is just becoming very exciting; courtesy persons like you.

    Peter Ng'ang'a June 20, 2020 2:09 pm Reply
  • you are making everything so complicated , plus the reference example is not working

    E F June 20, 2020 2:09 pm Reply
  • awesome!!!
    thank you so much mr gaga.

    mad nor June 20, 2020 2:09 pm Reply
  • Awesome.
    Thanks u very much for such a detail and simple explanation.

    Great Work..

    Sizzler Sizzle June 20, 2020 2:09 pm Reply
  • Wow. I have struggled with this function in different forms and here you are making me an expert after watching this 👏🏿👏🏿👏🏿👏🏿👏🏿

    mike obasuyi June 20, 2020 2:09 pm Reply
  • In the conditional table array example, how would I rewrite the Formula to find the person with the largest number for the region you specify?

    tubeampsrule1 June 20, 2020 2:09 pm Reply
  • Thanks!

    FRANKWHITE1996 June 20, 2020 2:09 pm Reply
  • 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!

    MDE SASF June 20, 2020 2:09 pm Reply
  • great example! can indirect be used in conjunction of SUMIFS ?

    Chelsea C June 20, 2020 2:09 pm Reply
  • This is very informative and helpful!

    MaxDouglas UK June 20, 2020 2:09 pm Reply
  • it's the best in YOuTube
    Q: how to get the last value in rows?
    thanks

    AbuSaad Harbi June 20, 2020 2:09 pm Reply
  • Great vid. Thank you.

    Liz 1968 June 20, 2020 2:09 pm Reply
  • I had seen many videos on Indirect function and this actually is the best.Thank you

    Arun June 20, 2020 2:09 pm Reply
  • Thank god for this video you are a lifesavor!!

    Dallas Cummaro June 20, 2020 2:09 pm Reply

Leave a Comment

Your email address will not be published. Required fields are marked *