Lookups
ADDRESS
Description: Returns the address of a cell in a worksheet given a specified row and column numbers.
Example:
ADDRESS(row_num, column_num, [abs_num], [a1]. [sheet_text])
Choose
Description: Returns the value from a range of values on a specific index.
Example:
Choose(index, valuearray)
Column
Description: Returns the column index of the provided column in range.
Example:
Column(range)
ERROR.TYPE
Description: Returns an integer for the given error value that denotes the type of error given
Example:
ERROR.TYPE(value)
Exact
Description: Compares two values ignoring the styles and returns the boolean value as true or false.
Example:
Exact(value1, value2)
Find
Description: Finds a portion of a string from a particular text and returns the location of the string.
Example:
Find(lookfor, lookin, start)
HLOOKUP
Description: Finds a value in one row and returns the corresponding value in another row.
Example:
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)
IFERROR
Description: Tests if an initial given value or expression returns an error.
Example:
IFERROR(value, value_error)
IFNA
Description: Returns the value specified if the formula returns the #N/A error; otherwise, it returns the result of the given formula.
Example:
IFNA(Formula_value, value_if_na)
Index
Description: Returns the exact value from the provided row index and column index from a specific range.
Example:
Index(range,row,col)
Indirect
Description: Returns the reference as a string instead of providing the content or range within it.
Example:
Indirect(content)
IsBlank
Description: Checks for blank or null values.
Example:
IsBlank(value)
IsErr
Description: Checks whether a value is an error.
Example:
IsErr(value)
ISERROR
Description: Returns True if cell holds an error.
Example:
ISERROR(value)
ISEVEN
Description: Returns True if given number is an even number, and returns FALSE if the given number is odd.
Example:
ISEVEN(value)
IsLogical
Description: Checks whether a value is a logical value and returns a TRUE or FALSE.
Example:
IsLogical(value)
IsNA
Description: Returns a boolean value after determining that the provided value is a #NA error value.
Example:
IsNA(value)
IsNonText
Description: Returns the boolean value after determining that the provided value is not a string.
Example:
IsNonText(text)
ISNUMBER
Description: Returns True if cell holds a number.
Example:
ISNUMBER(value)
ISODD
Description: Returns True if given number is an odd number, and returns FALSE if the given number is even.
Example:
ISODD(value)
ISREF
Description: Returns the logical value TRUE if the given value is a reference value; otherwise the function returns FALSE.
Example:
ISREF(given_value)
IsText
Description: Returns a boolean value after determining that the provided value is a string.
Example:
IsText(text)
LOOKUP
Description: Returns a value either from a one-row or one-column range, or from an array.
Example:
LOOKUP(lookup_value, lookup_vector, result_vector)
Match
Description: Searches for a specified value in an array and returns the relative position of that item.
Example:
Match(value, array, match_type)
NA
Description: Returns the #N/A error when a formula is unable to find a value that it needs.
Example:
NA()
Offset
Description: Returns a reference to a range that is offset a number of rows and columns from any given range or cell.
Example:
Offset(range, rows, columns, height, width)
T
Description: Tests whether the given value is text or not, then returns the given text.
Example:
T(value)
VARLOOKUP
Description: Finds a value in within given key/value pairs
Example:
VARLOOKUP(lookup_value, {key:value})
VLOOKUP
Description: Finds a value in one column and returns the corresponding value in another column.
Example:
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)