ADDRESS
ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])
Returns a cell reference as a string. Learn more
Apri schedaFunzioni Google Sheets
Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
CHOOSE
CHOOSE(index, choice1, [choice2, ...])
Returns an element from a list of choices based on index. Learn more
Apri schedaCOLUMN
COLUMN([cell_reference])
Returns the column number of a specified cell, with `A=1`. Learn more
Apri schedaCOLUMNS
COLUMNS(range)
Returns the number of columns in a specified array or range. Learn more
Apri schedaFORMULATEXT
FORMULATEXT(cell)
Returns the formula as a string. Learn more.
Apri schedaGETPIVOTDATA
GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]
Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. Learn more
Apri schedaHLOOKUP
HLOOKUP(search_key, range, index, [is_sorted])
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more
Apri schedaINDEX
INDEX(reference, [row], [column])
Returns the content of a cell, specified by row and column offset. Learn more
Apri schedaINDIRECT
INDIRECT(cell_reference_as_string, [is_A1_notation])
Returns a cell reference specified by a string. Learn more
Apri schedaLOOKUP
LOOKUP(search_key, search_range|search_result_array, [result_range])
Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Learn more
Apri schedaMATCH
MATCH(search_key, range, [search_type])
Returns the relative position of an item in a range that matches a specified value. Learn more
Apri schedaOFFSET
OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])
Returns a range reference shifted a specified number of rows and columns from a starting cell reference. Learn more
Apri schedaROW
ROW([cell_reference])
Returns the row number of a specified cell. Learn more
Apri schedaROWS
ROWS(range)
Returns the number of rows in a specified array or range. Learn more
Apri schedaSHEET
SHEET(value)
Returns the sheet number of the specified sheet or other reference. Learn more about the SHEET function.
Apri schedaVLOOKUP
VLOOKUP(search_key, range, index, [is_sorted])
Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Learn more
Apri schedaXLOOKUP
XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])
Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match. Learn more
Apri scheda