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.

How to use Lookup and Reference Formulas in Excel

The article in this webpage describes how to use the lookup and reference functions in Excel with the syntax, arguments, detailed explanation, and examples step by step.

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

Function
Description
ADDRESS Function
Cell address based on a given row and column number.
AREAS Function
Number iof areas in a given reference.
CHOOSE Function
A value or reference from a list of options based on the index number.
CHOOSECOLS Function
Specified columns from an array or range.
CHOOSEROWS Function
Specified rows from an array or range.
COLUMN Function
Column number of the selected cell reference.
COLUMNS Function
Number of columns in an array or reference.
DROP Function
Removes a specified number of rows or columns from the start or end of an array.
EXPAND Function
Expands an array to a specified number of rows and columns.
FIELDVALUE Function
All matching fields from the linked data type specified in the value argument.
FILTER Function
Filters a range of data based on one or more criterias that you specify.
FORMULATEXT Function
Formula in text format from the cell reference.
GETPIVOTDATA Function
Specific data from a pivot table.
GROUPBY Function
A summary of data via a formula.
HLOOKUP Function
Searches for a value in the top row of an array and return the value from a row you specify.
HSTACK Function
Combining each of the array horizontally into one array.
HYPERLINK Function
Hyperlink from a given destination and link text.
IMAGE Function
Insert a image in a cell from a source location along with alternative text.
INDEX Function
Value in a range or array based on the row and column numbers.
INDIRECT Function
Reference specified by a text string.
LOOKUP Function
Looks up a value in a single column or row to find a value from the same position in another column or row.
MATCH Function
Searches a specified value in a range and returns the position of that value in the array or range.
OFFSET Function
Value of a cell or range which is a specified number of rows and columns from a cell or range.
ROW Function
Row number in a given range.
ROWS Function
Number of rows in a given range.
RTD Function
Real time data from a program which supports COM automation.
SORT Function
Sorts the data of a range in ascending or descending order.
SORTBY Function
Sorts the data of a range based on the values in a corresponding range.
TAKE Function
Specified number of contiguous rows or columns from the start or end of a range.
TOCOL Function
Range in a single column.
TOROW Function
Range in a single row.
TRANSPOSE Function
Rotates the data in rows into columns and columns into rows.
UNIQUE Function
Rotates the data in rows into columns and columns into rows.
VLOOKUP Function
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 Function
Combines arrays vertically and in sequence into a larger array.
WRAPCOLS Function
Wraps the provided row or column of values by columns after a specified number of values.
WRAPROWS Function
Wraps the provided row or column of values by rows after a specified number of values.
XLOOKUP Function
Search for a specified value from a table or range of cells.
XMATCH Function
Relative position of a value in an array or range.

Learn More

Function
Description
CLEAN Function
Search for a specified value from a table or range of cells.
DATEDIF Function
Number of days, months or years between two dates.

0 Comments

Lookup and Reference Formulas in Excel

Excel Formulas (Category)

» Financial Formulas in Excel

» Logical Formulas in Excel

» Text Formulas in Excel

» Date and Time Formulas in Excel

» Lookup and Reference Formulas in Excel

» Math and Trig Formulas in Excel

» Statistical Formulas in Excel

» Engineering Formulas in Excel

» Cube Formulas in Excel

» Information Formulas in Excel

» Compatibility Formulas in Excel

» Web Formulas in Excel

Excel Tutorial Part 1 (Basic)

» Excel Basics

» Excel Home

» Excel Workbook

» Excel Template

» Excel Cell

» Excel Password

Excel Tutorial Part 2 (Format)

» Excel Clipboard

» Excel Format Font

» Excel Format Alignment

» Excel Format Number

» Excel Border

» Excel Conditional Formatting

Excel Tutorial Part 3 (Data)

» Excel Sort Data

» Excel Filter Data

» Excel Text to Columns

» Excel Data Validation

» Excel Flash Fill

» Excel Remove Duplicates

» Excel Relationships

» Excel Consolidate

» Excel What-If Analysis

» Excel Group

» Excel Charts

» Excel Table

» Excel PivotTable

Excel Tutorial Part 4 (Find)

» Excel Find and Replace

» Excel Go To

» Excel Select Objects

» Excel Selection Pane

Excel Tutorial Part 5 (Review)

» Excel Spell Check

» Excel Smart Lookup

» Excel Translate

» Excel Comments & Notes

» Excel Protect

» Excel Hide Ink

Excel Tutorial Part 6 (View)

» Excel Workbook Views

» Excel Formula Bar

» Excel Zoom

» Excel Window

» Excel Macros

Excel Tutorial Part 7 (Fx)

» Excel Formulas (Category)

» Excel Formulas (Alphabetical Order)

» Excel Errors

» Excel Name Manager

» Excel Formula Auditing

» Excel Watch Window

» Excel Calculation Options

Excel Tutorial Part 8 (Other)

» Excel Add-ins

» Excel Shortcuts