Lookup and Reference Formulas in Excel

Lookup and reference formulas in Excel are used to to cross reference between different data. The lookup and reference formulas in Excel can refer to a cell or array to match the value in another cell or array.

In this tutorial page, you will learn how to use all the lookup and reference formulas in Excel with detailed explanations, examples and videos.

Lookup and Reference Formulas in Excel

Lookup and Reference Formulas in Excel | Rath Point

All Lookup and Reference Formulas in Excel

Click on any of the below lookup and reference formulas in Excel to get the detailed information about it.

ADDRESS Formula in Excel

AREAS Formula in Excel

CHOOSE Formula in Excel

CHOOSECOLS Formula in Excel

CHOOSEROWS Formula in Excel

COLUMN Formula in Excel

COLUMNS Formula in Excel

DROP Formula in Excel

EXPAND Formula in Excel

FIELDVALUE Formula in Excel

FILTER Formula in Excel

FORMULATEXT Formula in Excel

GETPIVOTDATA Formula in Excel

HLOOKUP Formula in Excel

HSTACK Formula in Excel

HYPERLINK Formula in Excel

IMAGE Formula in Excel

INDEX Formula in Excel

INDIRECT Formula in Excel

LOOKUP Formula in Excel

MATCH Formula in Excel

OFFSET Formula in Excel

ROW Formula in Excel

ROWS Formula in Excel

RTD Formula in Excel

SORT Formula in Excel

SORTBY Formula in Excel

TAKE Formula in Excel

TOCOL Formula in Excel

TOROW Formula in Excel

TRANSPOSE Formula in Excel

UNIQUE Formula in Excel

VLOOKUP Formula in Excel

VSTACK Formula in Excel

WRAPCOLS Formula in Excel

WRAPROWS Formula in Excel

XLOOKUP Formula in Excel

XMATCH Formula in Excel

Summary of all Lookup and Reference Formulas in Excel

ADDRESS

Cell address based on a given row and column number.

AREAS

Number iof areas in a given reference.

CHOOSE

A value or reference from a list of options based on the index number.

CHOOSECOLS

Specified columns from an array or range.

CHOOSEROWS

Specified rows from an array or range.

COLUMN

Column number of the selected cell reference.

COLUMNS

Number of columns in an array or reference.

DROP

Removes a specified number of rows or columns from the start or end of an array.

EXPAND

Expands an array to a specified number of rows and columns.

FIELDVALUE

All matching fields from the linked data type specified in the value argument.

FILTER

Filters a range of data based on one or more criterias that you specify.

FORMULATEXT

Formula in text format from the cell reference.

GETPIVOTDATA

Specific data from a pivot table.

HLOOKUP

Searches for a value in the top row of an array and return the value from a row you specify.

HSTACK

Combining each of the array horizontally into one array.

HYPERLINK

Hyperlink from a given destination and link text.

IMAGE

Insert a image in a cell from a source location along with alternative text.

INDEX

Value in a range or array based on the row and column numbers.

INDIRECT

Reference specified by a text string.

LOOKUP

Looks up a value in a single column or row to find a value from the same position in another column or row.

MATCH

Searches a specified value in a range and returns the position of that value in the array or range.

OFFSET

Value of a cell or range which is a specified number of rows and columns from a cell or range.

ROW

Row number in a given range.

ROWS

Number of rows in a given range.

RTD

Real time data from a program which supports COM automation.

SORT

Sorts the data of a range in ascending or descending order.

SORTBY

Sorts the data of a range based on the values in a corresponding range.

TAKE

Specified number of contiguous rows or columns from the start or end of a range.

TOCOL

Range in a single column.

TOROW

Range in a single row.

TRANSPOSE

Rotates the data in rows into columns and columns into rows.

UNIQUE

Rotates the data in rows into columns and columns into rows.

VLOOKUP

Search for a value in the first column of a range and return a corresponding value from a specified column in the same row.

VSTACK

Combines arrays vertically and in sequence into a larger array.

WRAPCOLS

Wraps the provided row or column of values by columns after a specified number of values.

WRAPROWS

Wraps the provided row or column of values by rows after a specified number of values.

XLOOKUP

Search for a specified value from a table or range of cells.

XMATCH

Relative position of a value in an array or range.

» Financial Formulas

» Logical Formulas

» Text Formulas

» Date & Time Formulas

» Lookup & Ref Formulas

» Math & Trig Formulas

» Statistical Formulas

» Engineering Formulas

» Cube Formulas

» Information Formulas

» Compatibility Formulas

» Web Formulas