Informational functions provide a variety of searching and reporting procedures.
|
Picks out a value or expression based on the index.
| |
|
Returns the column number for the given cell or formula.
| |
|
Returns an error. Useful embedding in other functions or conditional statements. See also the NA function.
| |
|
This function looks for a value in the top row of a table or array and returns the value from the same column for the row you specify.
| |
|
Returns the value of a cell in a range based on the row and column offsets.
| |
|
This function looks for a value a table or array and returns the value from the cells where a match is found.
| |
|
This function looks for a value a table or array and returns the offset value for the first instance. The search-range is checked row by row from left to right, until the value is found. If the search criteria is not met, the error #N/A! is returned.
| |
|
Returns a not available error. Useful embedding in other functions or conditional statements. See also the ERROR function.
| |
|
Returns the row number for the given cell or formula.
| |
|
Reports the format of the evaluated expression or reference. The function returns the following values:
| |
|
|
1 - Blank 2 - Logical 3 - Number 4 - Date/Time 5 - Error 6 - Text
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This function looks for a value in the first column of a table or array and returns the value from the same row or for the row you specify. |