• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Lookup & Reference Functions

Lookup & Reference Functions

ADDRESS(row_num,column_num,abs_num,a1,sheet_text)Returns a reference as text to a single cell in a worksheet.
AREAS(reference)Returns the number of areas in a reference.
CHOOSE(index_num,value1,value2,…)Chooses a value from a list of values.
COLUMN(reference)Returns the column number of a reference.
COLUMNS(array)Returns the number of columns in a reference.
HLOOKUP(lookup_value,table_array,row_index_num,…)Looks in the top row of a table and returns the value of the indicated cell.
HYPERLINK(link_location,friendly_name)Creates a shortcut that opens a document stored on a network computer or the Internet.
INDEX(…)Uses an index to choose a value from a reference or array.
INDIRECT(ref_text,a1)Returns a reference indicated by a text value.
LOOKUP(…)Looks up values in a vector or array.
MATCH(lookup_value,lookup_array,match_type)Looks up values in a reference or array.
OFFSET(reference,rows,cols,height,width)Returns a reference offset from a given reference.
ROW(reference)Returns the row number of a reference.
ROWS(array)Returns the number of rows in a reference.
TRANSPOSE(array)Returns the transpose of an array.
VLOOKUP(lookup_value,table_array,col_index_num,…)Looks in the first column of a table and moves across the row to return the value of a cell.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint