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.

📁 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.

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.

• 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

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.

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

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.

• 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

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.

Now, follow these steps.

⬇️⬇️ STEPS ⬇️⬇️

• Firstly, select cell G6 and enter the formula.

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

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.

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

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.

• 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.

Related Articles

• If Cell Contains Text From List Then Return Value in Excel