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