Lookup And Reference Functions Reference. Reference functions return informations about the cell reference as text values such as the entire address the row or column. If the LOOKUP Function is attempting to reference cells that do not exist LOOKUP returns the REF.
Returns the number of columns in a reference. The MATCH function returns the. Looks up values in a vector.
Excel comes with multiple Lookup and Reference functions that let you find matching values.
Uses an index to choose a value from a reference or array. List value dataset Returns the index number in dataset where value first occurs. Excel Lookup and Reference Functions. Returns the number of areas in a reference.