Index is a reference or number between 1 and 30 indicating which value is to be taken from the list. Uses an index to return a value from a list of up to 30 values. Reference is the reference to a cell or cell range. A range can consist of contiguous cells or a single cell. Returns the number of individual ranges that belong to a multiple range. Column is the column number for the cell reference (the number, not the letter). Row is the row number for the cell reference.
The name of the sheet can also be specified.
Optionally, whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1) can be determined. Returns a cell address (reference) as text, according to the specified row and column numbers. Use spreadsheet functions to search and address cell ranges and provide feedback regarding the contents of a cell or range of cells.You can use functions such as HYPERLINK() and DDE() to connect to other documents or data sources.
0 kommentar(er)
