この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
INDIRECT(ref_text, [a1])The INDIRECT function evaluates a text string as a cell reference. It is useful for creating dynamic references that change based on the content of other cells or formulas.
=INDIRECT("A1")結果: Value in A1
Returns the value contained in cell A1.
=INDIRECT(B1)結果: Value of the cell referenced in B1
If cell B1 contains the text 'C5', this formula returns the value of cell C5.
This usually happens if the text string does not point to a valid cell reference or if the referenced workbook is closed.