# Sheet | Spreadsheet | Knowledge Base

• ## LAMBDA

Create custom functions with personalized calculations that can be reused within the spreadsheet using the LAMBDA function.  Syntax LAMBDA(name; cal_or_name; [name]; [name2]...) name: The variable to be used in the defined calculation. cal: The ...
• ## LET

Allows defining of names, values and calculations within the function. These names can only be used within the formula.   Syntax   LET(name, value, cal_or_name, [value], [cal_or_name], [value2], [cal_or_name2]...) name: The names to which you can ...
• ## IMPORTRANGE

Imports values from a given range of cells from another specified spreadsheet (workbook) in Zoho Sheet.   Syntax   IMPORTRANGE( spreadsheet_url; range ) spreadsheet_url : The link of the source spreadsheet from where the range is to be imported. Eg., ...
• ## TOP

Returns top part/whole array from the top of given data_range after sorting it in descending order.   Syntax   TOP(data_range; sort_index; [result_index]; [result_sets]) data_range: The array or range containing the input data. E.g. A2:D8 sort_index: ...
• ## BOTTOM

Returns part/whole array from the top of given data_range after sorting it in ascending order.   Syntax   BOTTOM(data_range; sort_index; [result_index]; [result_sets]) data_range: The array or range containing the input data. E.g. A2:D8 sort_index: ...
• ## SEQUENCE

Returns a list of sequential numbers as an array in the provided cell range.   Syntax   SEQUENCE(row; [column]; [first_value]; [step]) row: Number of rows to be filled with the sequential array. Eg., 2 column: Number of columns to be filled with the ...
• ## SORTBY

Sorts a given array or range of values based on a corresponding array or range, and the specified criteria. It is a dynamic array function, where the result array may increase or decrease in size based on the source range.   Syntax   SORTBY(range; ...
• ## SORT

Sorts a given array or range of values based on the specified criteria. It is a dynamic array function, where the result array may increase or decrease in size based on the source range.   Syntax   SORT(range; [sort_by]; [order]; [direction]) range: ...
• ## XMATCH

Returns the relative position of the given value in a given range. XMATCH is an advanced version of the MATCH function.   Syntax   XMATCH(search_item; search_region; [match_mode]; [search_mode]) search_item: The value to search for in the ...
• ## XLOOKUP

Tests the search_table for the given lookup_value and returns a corresponding value from the result_table. XLOOKUP is an advanced version of the VLOOKUP and HLOOKUP functions that searches both vertically and horizontally.   Syntax   ...
• ## VLOOKUP

VLOOKUP checks the first column of the given data table for the specified value and returns a corresponding value, in that row, based on the column given.   Syntax   VLOOKUP( lookup_value; data_table; column_index; [mode] ) lookup_value : The value ...
• ## SHEET

Returns the sheet number for a given cell reference.   Syntax   SHEET(cell_ref) cell_ref: The cell reference whose sheet number you want. If omitted, it returns the sheet number of the current cell containing the formula. E.g. SHEET.A1   Remarks The ...
• ## ROWS

Returns the number of rows in a given range.   Syntax   ROWS(cell_ref) cell_ref: The cell or range within which you want to calculate the number of rows. E.g. A1:C8   Examples   Formula Result =ROWS( A1:C8 ) 8 =ROWS( A5:C5 ) 1 =ROWS(Sales_data) 9 Get ...
• ## ROW

Returns the row number for a given cell reference.   Syntax ROW(cell_ref) cell_ref: The reference of the cell whose row number you want to obtain. If omitted, it returns the row number of the current cell containing the formula. E.g. A5:C5   Remarks ...
• ## OFFSET

Returns a reference that is a given number of rows and columns away from the specified cell/range.   Syntax   OFFSET(reference; row_offset; col_offset; [new_height]; [new_width]) reference: The starting cell/range from which the given offset ...
• ## MATCH

Returns the relative position of the given value in a given range.   Syntax   MATCH(search_item; search_region; [match_type]) search_item: The value to search for in the given range. E.g. "Ming Yin" search_region: The row/column to search. E.g. C2:C7 ...
• ## LOOKUP

Searches for a given value in a sorted row/column and returns a corresponding value from the given row/column. If more than one exact match appears, LOOKUP takes the value in a random order. If no exact match appears, LOOKUP takes the next smallest ...
• ## INDIRECT

Returns a cell reference, given a text string. The obtained reference is evaluated and the function finally returns the cell value.   Syntax   INDIRECT(text_ref; [ref_type]) text_ref: The string that represents the cell reference to evaluate. E.g. D3 ...
• ## INDEX

Returns a value from a table, given a row and column number.   Syntax   INDEX(data_table; row; column; area_number) data_table: The cell range to test. E.g. A1:D8 row: Row number of the cell containing the value to return, in the given data_table. ...
• ## IMAGE

Inserts the given image into the specified cell.   Syntax   IMAGE(url, [mode]) url: The url of the image to insert. E.g. " https://images.pexels.com/photos/459225/pexels-photo-459225.jpeg?auto=compress&cs=tinysrgb&dpr=1&w=500" mode: Indicates the ...

• ## HLOOKUP

HLOOKUP checks the first row of the given data table for the specified value and returns a corresponding value in that column, based on the row given.   Syntax   HLOOKUP(lookup_value; data_table; row_index; [mode]) lookup_value: The value to look for ...
• ## ERRORTYPE

Returns a number corresponding to each error value. It gives #N/A if there is no error in the given reference.   Syntax   ERRORTYPE(reference) reference: The cell reference given as input for the function. E.g. A3     Error Type Result #CIRCULARREF! ...
• ## COLUMNS

Returns the number of columns in a given array or reference.   Syntax   COLUMNS(cell_ref) cell_ref: The reference for the cell or range within which you want to calculate the number of columns. E.g. A1:C8   Examples   Formula Result =COLUMNS( A1:C8 ) ...
• ## COLUMN

Returns the column number, given a cell reference. Starts with 1 for Column A.   Syntax   COLUMN(cell_ref) cell_ref: The cell reference whose column number you want to obtain. If omitted, it returns the column number of the cell containing the ...
• ## CHOOSE

Returns a value from a list, given an index number.   Syntax   CHOOSE(index; value1; [value2]; ...) value: The values from which one is to be returned. Can be a value, cell reference, or formula. E.g. "Sunday","2/2/19" index: Specifies which values ...
• ## AREAS

Returns the number of areas in a given reference. An area refers to a range of adjacent cells or a single cell.   Syntax   AREAS(cell_ref) cell_ref: The cell reference in which you want to find the number of areas. Can be a single range, or multiple ...