Returns the reference specified by a text string.
ฟังก์ชันนี้ทำงานใน 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.