이 함수는 Google Sheets에서도 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.