Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Lookup
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en

Instruction: ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])
Language: Sheets
Context: Lookup
Returns: Returns a cell reference as a string. Learn more

Instruction: CHOOSE(index, choice1, [choice2, ...])
Language: Sheets
Context: Lookup
Returns: Returns an element from a list of choices based on index. Learn more

Instruction: COLUMN([cell_reference])
Language: Sheets
Context: Lookup
Returns: Returns the column number of a specified cell, with `A=1`. Learn more

Instruction: COLUMNS(range)
Language: Sheets
Context: Lookup
Returns: Returns the number of columns in a specified array or range. Learn more

Instruction: FORMULATEXT(cell)
Language: Sheets
Context: Lookup
Returns: Returns the formula as a string. Learn more.

Instruction: GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]
Language: Sheets
Context: Lookup
Returns: Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. Learn more

Instruction: HLOOKUP(search_key, range, index, [is_sorted])
Language: Sheets
Context: Lookup
Returns: 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

Instruction: INDEX(reference, [row], [column])
Language: Sheets
Context: Lookup
Returns: Returns the content of a cell, specified by row and column offset. Learn more

Instruction: INDIRECT(cell_reference_as_string, [is_A1_notation])
Language: Sheets
Context: Lookup
Returns: Returns a cell reference specified by a string. Learn more

Instruction: LOOKUP(search_key, search_range|search_result_array, [result_range])
Language: Sheets
Context: Lookup
Returns: 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

Instruction: MATCH(search_key, range, [search_type])
Language: Sheets
Context: Lookup
Returns: Returns the relative position of an item in a range that matches a specified value. Learn more

Instruction: OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])
Language: Sheets
Context: Lookup
Returns: Returns a range reference shifted a specified number of rows and columns from a starting cell reference. Learn more

Instruction: ROW([cell_reference])
Language: Sheets
Context: Lookup
Returns: Returns the row number of a specified cell. Learn more

Instruction: ROWS(range)
Language: Sheets
Context: Lookup
Returns: Returns the number of rows in a specified array or range. Learn more

Instruction: VLOOKUP(search_key, range, index, [is_sorted])
Language: Sheets
Context: Lookup
Returns: 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

Instruction: XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])
Language: Sheets
Context: Lookup
Returns: 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