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)