Lookup a Value and Return a Different Cell From the Table in Excel!!
Tags: kutoolsexceltutorial, lookupavalueandretur, kutools
Published: 2020-09-25 03:44:33

---
title: Lookup a Value and Return a Different Cell From the Table in Excel!!
published: true
date: 2020-09-24 11:53:23 UTC
tags: KutoolsExcelTutorial,LookupaValueandRetur,Kutools
canonical_url: https://geekexcel.com/lookup-a-value-and-return-a-different-cell-from-the-table-in-excel/
---

## Lookup a Value and Return a Different Cell From the Table in Excel:

In this article, we are going to learn how to **Lookup a Value and Return a Different Cell From the Table in Excel Office 365** using **Kutools.** 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)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## **Lookup a Value and Return a Different Cell From the Table:**

To lookup a value and return a different cell from the table, do as follows.

- Let’s consider an example to know how to do this. In the below example image, you can see the list of **names** in **Column A** , and their **marks** are given in **Column**  **B**.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-100.png)<figcaption id="caption-attachment-14578">Example data</figcaption>

- You have to **select a cell** to display the result.
- On the **Kutools Tab, select** the **Formula Helper option, choose** the **Formula Helper** option from the menu.

![Choose Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Formula-Helper-option.png)<figcaption id="caption-attachment-14579">Choose Formula Helper option</figcaption>

- It will open the  **Formula**  **Helper dialog box.**
- In that dialog box, **select** the **Look for a value in list**  option from **Choose**  **a**  **Formula** box.
- You need to **check** the **filter** box and **enter**  **look<sup> </sup>** into the text box to filter the formula quickly.
- **Table\_array** box – You need to click the button to **select the table** which contains the Lookup Value and the result value.
- **Lookup\_value** box – You have to click the button to **select the cell contains the Lookup value** or you can directly enter the value in this box.
- In the **Column** box, you have to click the button to **select the column** which contains the returning value.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Formula-Helper-Dialog-Box.png)<figcaption id="caption-attachment-14580">Formula Helper Dialog Box</figcaption>

- Finally, you need to **click** the **OK** button to get the result.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-4.png)<figcaption id="caption-attachment-14581">Result</figcaption>

### Related Topics:

- [**VLOOKUP Function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)

## Closure:

In this article, you can understand the steps to **Lookup a Value and Return a Different Cell From the Table in Excel Office 365** using **Kutools. ** Leave your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!