Excel Lookup and Reference Functions

Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.

FunctionPurposeParam,Optional
HYPERLINK Create a clickable link. link_locationfriendly_name
LOOKUP Look up a value in a one-column range lookup_value lookup_vectorresult_vector
MATCH Get the position of an item in an array lookup_value lookup_arraymatch_type
ROW Get the row number of a reference reference
ROWS How to use the Excel ROWS function to Get the number of rows in an array or reference. array
TRANSPOSE Flip the orientation of a range of cells array
VLOOKUP Lookup a value in a table by matching on the first column value table col_indexrange_lookup