Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

INDIRECT Formula

INDIRECT formula returns the reference to a cell or range on the base of its string representation. 

Syntax for INDIRECT formula

INDIRECT(ref_text, [a1] )

Parameters Details:

ref_text: A textual representation of a cell reference.

a1: Optional. It is either a TRUE or FALSE value. TRUE indicates that string_reference will be interpreted as an A1-style reference. FALSE indicates that string_reference will be interpreted as an R1C1-style reference. If this parameter is omitted, it will interpret string_reference as an A1-style.

Returns

The INDIRECT formula returns the reference to a cell or range.