# If One Cell Equals Another Then Return Another Cell in Excel

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.

## 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. 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 IDs. 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. 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 IDs horizontally since HLOOKUP looks for value horizontally.

⬇️⬇️ 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. `📌`  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.

## Related Articles

(Visited 131 times, 1 visits today) #### Priti

Hello! Welcome to my Profile. I am Priti. I'm now working and researching Microsoft Excel, and I'll share articles on it here. I am passionate about problem-solving, and I hope these articles will help you. Please leave a remark if you have any queries, and I will do my best to find an appropriate answer.

We will be happy to hear your thoughts 