Microsoft Excel is an excellent tool for data analysis and visualization. For data analysis or visualization, there comes such a situation that if one cell equals to another, then return another cell in Excel. Thus, this article will demonstrate six easy ways to return the value in another cell if one cell equals another.

**📁 Download Excel File**

Download the Excel file used for the demonstration from the link below.

## Learn to Return Another Cell If One Cell Equals Another in Excel with These 6 Ways

This article uses distinct functions to return the value in another cell if one cell equals another. We have used **IF**, **ISNUMBER**, **SEARCH**, **VLOOKUP**, **HLOOKUP**, **INDEX**, and **MATCH **functions. Now, let us dig into the methods and formulas to return another cell if one cell equals another in Excel.

**method 1**

**1. Using IF Function**

**IF function** logically compares a value and your desired outcome and can return two results: one is if **TRUE **and another one is **FALSE**. In this particular method, we are going to use this function to return the value in another cell if one cell equals another. For that, we have a data set containing **the Product Name** and the **City Name** where to deliver the product is presented. Now we want to know if it would deliver to **New York**.

Let us see the steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- First, select cell
**D6**and insert the formula.

**=IF(C6=”New York”,”Yes”,”No”)**

**🔨 Formula Breakdown**

Here, the formula inserted in **D6** is:

**IF(C6=”New York”,”Yes”,”No”)**

👉 This part **C6=”New York” **is the logical test part that compares the text string in cell **D6** with **New York**.

👉 If the text string in cell **D6** matches, it returns **“Yes”** and otherwise **“No”**.

- Then, double-click on fill handle icon or drag it down.

- Finally, we will have the desired result.

**📕 Read More: 8 Ways to Return Value If Cell Contains Text in Excel**

**method 2**

### 2. Using IF, ISNUMBER & SEARCH Functions

**The ISNUMBER function** checks a number value and returns **TRUE **or **FALSE**. On the other hand, **IF function** compares the given value with desired value and returns **TRUE **or **FALSE**. The **SEARCH function** searches the text string in another text string and returns the number of the starting position of the first text string from the first character of the second text string. In this very method, we are going to use the previous dataset to demonstrate how to use these two formulae to return value inside another cell if one cell equals another. Let us see the steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- First, select cell
**D6**and insert the formula.

**=IF(ISNUMBER(SEARCH(“New York”,C6)),”delivered”,”not delivered”)**

**🔨 Formula Breakdown**

Here, the formula inserted in **D6** is:

**IF(ISNUMBER(SEARCH(“New York”,C6)),”delivered”,”not delivered”)**

`👉`

Here, this part **SEARCH(“New York”,C6) **searches the text string in the cell **C6**.Since the text string in** C6** is the exact match of **“New York”,** so it returns 1.

`👉`

Now, the** ISNUMBER** function returns true if the number is 1 otherwise returns false.

`👉`

Depending on that **IF** function displays ‘’delivered’.

- Then, double-click on
**Fill Handle**or drag, and finally, we will get our outcome.

**method 3**

### 3. Applying VLOOKUP Function

**The VLOOKUP function **finds something in a table or a range by row. This method will use this function to return the value in another cell if one cell equals another. Here we will use another data set containing the **Book ID** and **Book Name** of ABC Bookstore. And there is another table in which we have a list of selling dates and book IDs that sold that day. We want to find out the **Book Name** for the given **Book ID**s.

Let us see go through the steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- First, select cell
**G6**and enter the formula.

**=VLOOKUP($F6,$B$6:$C$10,2,0)**

**🔨 Formula Breakdown**

Here, the formula inserted in **G6** is:

**=VLOOKUP($F6,$B$6:$C$10,2,0)**

`👉`

In this function, first, **$F6** is the value that we have to look up.

`👉`

**$B$6:$C$10 **is the array where the function will then search for particular lookup value.

`👉`

Then 2 shows that we have to look up in the second column of the array and 0 represents that it needs to be the exact match.

- Then drag fill handle down to the last row and get the result.

**📕 Read More: VLOOKUP If Cell Contains a Word Within Text in Excel**

**method 4**

**4. Utilizing HLOOKUP Function**

**The HLOOKUP** **function **searches for a value in the top row of a table or an array of values and then returns a value in the same column from a row specified in the table or array. We will use the previous data set to demonstrate this function, but we have arranged the **Book names** and **ID**s horizontally since **HLOOKUP **looks for value horizontally.

Now, follow these steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- Firstly, select cell
**G6**and enter the formula.

**=HLOOKUP($J6,$C$5:$G$6,2,)**

**🔨 Formula Breakdown**

Here, the formula inserted in **G6** is:

**HLOOKUP($J6,$C$5:$G$6,2,)**

`👉`

In this function, first **$J6 **is the value to lookup.

`👉`

**$C$5:$G$6 **is the array where the function will now search for this particular lookup value.

`👉`

Then 2 shows that we have to look up in the second row of the array, and 0 represents that it needs to be the exact match.

- Then, drag fill handle down to the last row to get the result.

**Method 5**

### 5. Combining MATCH & INDEX Functions

This method will combine **INDEX** and **MATCH** functions to return value in another cell if one cell equals another. We will use the previous data set here too.

**⬇️⬇️ STEPS ⬇️⬇️**

- Select cell
**G6**and insert the formula.

**=INDEX($B$6:$C$10,MATCH($F6,$B$6:$B$10,0),2)**

**🔨 Formula Breakdown**

Here, the formula inserted in **G6** is:

**INDEX($B$6:$C$10,MATCH($F6,$B$6:$B$10,0),2)**

`👉`

here Match function searches for a value in F6 in the range B6:B10 and returns the relative position of the item that is 5.

`👉`

on the other hand INDEX function returns the value in the range B6:C10 for the specified reference which is 5 in this case.

- Then, drag fill handle down to the last row to get the result.

**method 6**

**6. Returning Cells from Different Worksheets**

In this section, we will show returning a value from a different worksheet. So for that, we have created another worksheet. In the ABC bookstore sheet, we have Book Name and Book ID and in the result sheet, we will get our value returned.

Now, let us go through the steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- First, we have our dataset in “
**ABC Bookstore**” worksheet, and we want our outcome in “**Result”**worksheet.

- Now, select the cell in the worksheet where you want your output. Here we select cell
**G6**in the result worksheet and enter the following formula.

**=LOOKUP($F6,’ABC Bookstore’!$B$5:$C$10)**

**🔨 Formula Breakdown**

Here, the formula inserted in **G6** is:

**LOOKUP($F6,’ABC Bookstore’!$B$5:$C$10)**

👉 In this function, first **$F6 **contains the value to lookup.

👉 **‘ABC Bookstore’!$B$5:$C$10 **is the array where the function will now search for this particular lookup value.

- Now drag or double-click on fill handle.

**📕 Read More: Excel Formula: If Cell Contains Text Then Return Value in Another Cell**

** **📝 Takeaways from This Article

`📌`

This article demonstrated 6 ways of returning to another cell if one cell equals another cells in Excel.

`📌`

In the first method, we showed the **IF **function to return another cell if one cell equals another cells in Excel.

`📌`

Then, we demonstrated a function that applies **IF, ISNUMBER**, and** SEARCH **functions to return another cell if one cell equals the other cell in Excel.

`📌`

Next, we employed the **VLOOKUP **function to return to another cell.

`📌`

After that, we showed the **HLOOKUP** function performing the value return to another cell if it matches with other cells.

`📌`

Then, we combined** INDEX **and** MATCH** functions to return another cell if one cell equals another cell in Excel.

`📌`

Finally, we demonstrated how to return cells from another worksheet.

## Conclusion

This article has demonstrated 6 ways of returning to another cell if one cell equals another cell in Excel. All these methods are incredibly effective and simple to use. We hope this article helps you. Please leave a remark if you have any queries. The author will do their best to find an appropriate answer.

For more guides like this, visit **Excelden.com**.