• 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