Funzione di Google Sheets

INDIRECT

Returns the reference specified by a text string.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

ref_textobbligatorioA text string that specifies a cell reference.
a1facoltativoA logical value that specifies the reference style (TRUE for A1 style, FALSE for R1C1 style; defaults to TRUE).

Esempi

=INDIRECT("A1")

Risultato: Value in A1

Returns the value contained in cell A1.

=INDIRECT(B1)

Risultato: Value of the cell referenced in B1

If cell B1 contains the text 'C5', this formula returns the value of cell C5.

Domande frequenti

Why does INDIRECT return a #REF! error?

This usually happens if the text string does not point to a valid cell reference or if the referenced workbook is closed.

Funzioni correlate

OFFSET INDEX ADDRESS