Directly understand Indirect..

Excel Indirect

"Thanks you everyone for your response. Today we are going to discuss the use of INDIRECT, most of the time you can not use it alone because it just create text into the ranges. So when to use, whenever you are working with the dynamic ranges. You can say it is the synonym of dynamic range in excel. Here we are going to explore it a more and understand the uses of this functions.. 

 

 

 

 

 

 

 

 

 

Lets start  :)

• Indirect -Convert text to range if text is valid range .

•  Syntax
1. ref_text = Enter the cell reference..
2. False or True = Option to select range style.
   
• False = R1C1 style (R3C4)
• True = A1 style (A5)
  

First Example..

•  You  can use for dynamic data validation, where you can create dependent list and use indirect in the validation.

• Company is the first dynamic list which has list as following
• Apple, Google, Microsoft 

• If you see Apple and other companies has list of product so the list is like company name again the product list
• Apple = iPhone, Mac, iPad
• Google = Pixel, Google Glass, Chromecase
• Microsoft = Lumia, Surface, Xbox

Now if you use indirect(Company) it will bring the first list in the cell where you will apply the validation, for example A1.

If you go to A2 and create data validation again the above mentioned cell like, indirect(A1)..boom.. you will get the product list here and whenever the first list changes the second list will also change.

Here you can fill the form and the file will be sent to you.

                                     AutoMateSheets                                  

 

 Here is the YouTube video, where I have explained everything..

Please get in touch for any query help or suggestion..
Youtube
Facebook Page
Twitter
Email: lkthecool@gmail.com