Excel Formulas to Get the Address of a Lookup Results!!
Tags: excelformula, excelformulas
Published: 2020-12-25 11:56:11

---
title: Excel Formulas to Get the Address of a Lookup Results!!
published: true
date: 2020-12-25 10:48:54 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-get-address-lookup-result/
---

For instance, you have a list of data, and you need to get the address of a certain lookup value. In this case, how could you deal with this task in Excel? Here are some cute formulas for you to **get the address of Lookup results in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to get the address of lookup result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-get-the-address-of-lookup-result.png)](https://geekexcel.com/excel-formulas-get-address-lookup-result/formulas-to-get-the-address-of-lookup-result/#main)<figcaption id="caption-attachment-20387">Formulas to get the address of lookup result</figcaption>
## Generic Formula:

- To get the address of a lookup result derived with the INDEX function, you can use the CELL function. Refer to the below formula.

**=[CELL](https://geekexcel.com/use-cell-function-in-microsoft-excel-365-simple-methods/)(“[address](https://geekexcel.com/how-to-use-address-function-in-microsoft-excel-365/)“,[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(row,range,0),column\_number))**

## Syntax Explanations:

- **CELL** – The Excel[**CELL function**](https://geekexcel.com/use-cell-function-in-microsoft-excel-365-simple-methods/) will help to return the information about a cell in a worksheet.
- **Address** – This function will help to create a cell address from a given row and column. Read more on the **[Address Function](https://geekexcel.com/how-to-use-address-function-in-microsoft-excel-365/)**.
- **INDEX** – In Excel, the **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** helps to return the value at a given position in a range or array.
- **MATCH** – This function will locate the position of a lookup value in a row, column, or table. Read more on the **[MATCH Function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)**.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input ranges in your worksheet.
- **Column Number** – It will contain the column number from the input data.

## Practical Example:

- Now, we are going to see how to get the address of the given value in Excel.
- Refer to the below image.
- Here, we will give the input values in **Column B** and **Column C**.
- Then, enter the given formula in the formula bar section.
- Finally, we can get the result in **Cell F4**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-81.png)<figcaption id="caption-attachment-20386">Example</figcaption>

## Wind-Up:

![🤞](https://s.w.org/images/core/emoji/13.0.1/72x72/1f91e.png) Hope you understood the simple formula used to **get the address of the lookup results in Excel**. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below. Click here to know more about **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!** Thank you so much for visiting our site!!

### Related Articles:

- **[Excel Formulas to Find the Nth Largest Value without Duplicates!!](https://geekexcel.com/excel-formulas-nth-largest-without-duplicates/)**
- **[Excel Formulas to Find Lowest N Values ~ Complete Tutorial!!](https://geekexcel.com/excel-formulas-find-lowest-n-values/)**