INDIRECT Formula in MS Excel

 INDIRECT Formula in MS Excel

The INDIRECT formula in MS Excel returns a reference to a range specified by a text string. It allows you to dynamically refer to cell ranges based on a cell value.

The syntax of the INDIRECT formula is as follows:

INDIRECT(ref_text, [a1])

Where:

• ref_text: The text string that specifies the reference to the range you want to return.
• [a1]: Optional. A logical value that specifies the type of reference in ref_text. If "a1" is TRUE or omitted, ref_text is interpreted as an A1-style reference. If "a1" is FALSE, ref_text is interpreted as an R1C1-style reference.

For example, if you have a cell named "Range1" that contains the reference "A1:A10", you can use the INDIRECT formula to refer to this range:

=SUM(INDIRECT("Range1"))

This would return the sum of the values in cells A1 to A10.

Note: The INDIRECT formula is a volatile formula, which means it recalculates whenever any change is made to the worksheet. This can slow down your workbook, so use it carefully and consider alternatives like INDEX and MATCH formulas when possible.