Lookup & Reference Functions in Excel
- Lookup Reference Functions in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
List of Lookup & Reference Functions in Excel
Lookup functions are essentially used to match lookup from one data set and finding the corresponding entry or output from another data set. It is divided into two parts - lookup and reference functions.
Here we discuss the top lookup and reference functions in excel
- ADDRESS function in Excel
- VLOOKUP and HLOOKUP in excel
- MATCH and INDEX Functions in Excel
- COLUMN and COLUMNS in Excel
- INDIRECT function in Excel
- REPLACE function in Excel
Address Function in Excel
Address function in Excel lets you derive the reference excel address of cell or a range passed in the parameter of the Address function Excel.
Choose Function in Excel
CHOOSE function is used to get a value from a data list based on the position selected.
Column Function in Excel
Column excel function is lookup/reference function in excel used to determine the first column value from the supplied reference range.
Columns Function in Excel
COLUMNS function is a built-in function in Microsoft Excel.
REPLACE Function in Excel
REPLACE Function in Excel is categorized under String or Text functions in MS Excel.
GetPivotData in Excel
GETPIVOTDATA is used to fetch the required data from the pivot table.
HLOOKUP in Excel
HLOOKUP Function is used for horizontally searching the value in the table array and provides the value from the same column based on the given index_number.
Hyperlink Excel Function
The Hyperlink in Excel sheet enables you to create a shortcut to a file or URL.
INDIRECT Function in Excel
INDIRECT function in excel has multiple usages. It returns the cell reference specified by a text string.
LOOKUP Excel Function
LOOKUP Excel Function returns a value from a range of values (a row or a column) or from an array.
Match Excel Function
MATCH Function in Excel is used to find out the position of a lookup value in a lookup array (row, column, or table).
VLOOKUP Excel Function
VLOOKUP Excel function is a built-in function in Microsoft Excel which has been categorized as a Lookup/Reference Function.
INDEX Excel Function
The Function INDEX returns the value / Position of the cell within a given table or a range.