Returns the reference specified by a text string.
Sintaxe
INDIRECT(ref_text, [a1])Argumentos
ref_textobrigatório
A text string that specifies a cell reference.
a1opcional
A logical value that specifies the reference style (TRUE for A1 style, FALSE for R1C1 style; defaults to TRUE).
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 A1Returns the value contained in cell A1.
=INDIRECT(B1)→Value of the cell referenced in B1If cell B1 contains the text 'C5', this formula returns the value of cell C5.
Prepare the reference string
Ensure the cell or formula contains the address you want to reference as a text string.
Enter the INDIRECT function
Type =INDIRECT( and select the cell containing the reference string or type the string in quotes.
This usually happens if the text string does not point to a valid cell reference or if the referenced workbook is closed.