Warning: Use of undefined constant WPLANG - assumed 'WPLANG' (this will throw an Error in a future version of PHP) in /hermes/walnacweb06/walnacweb06al/b1331/moo.excelforcommercecom/wp-content/plugins/LayerSlider/classes/class.km.autoupdate.v3.php on line 73 Excel for Commerce | indirect function in excel Archives | Excel for Commerce
18Nov2014

INDIRECT function in Excel: How to dynamically refer multiple sheets?

INDIRECT function in Excel returns the reference specified by a text string. The syntax for this excel function is as follows. Formula Syntax: INDIRECT( ref_text, [a1] ) ref_text can be the range of cells or a named range. [a1] can be TRUE or FALSE. TRUE is used to indicate that ref_text is in R1C1 style
  • 18 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, indirect function in excel,
Read more