![compare two columns in excel and return a third value compare two columns in excel and return a third value](https://i.stack.imgur.com/3Gfje.png)
![compare two columns in excel and return a third value compare two columns in excel and return a third value](https://i.stack.imgur.com/4kYvC.png)
“Milk” and “milk” are treated as the same in this comparison. If the cells A2 and B2 are the same, “Matched” value will show in cell C2 and if the cells A2 and B2 are not the same, then the “Not Matched” value will show as the output. This is a straightforward Excel IF function. We have used this formula in cell C2: =IF(A2=B2, “Matched”, “Not Matched”)
![compare two columns in excel and return a third value compare two columns in excel and return a third value](https://i.stack.imgur.com/uSWzI.png)
You might also want to compare two columns row by row like the following image.
#COMPARE TWO COLUMNS IN EXCEL AND RETURN A THIRD VALUE HOW TO#
Related: How to Compare Two Columns in Excel For Finding Differences 5) Compare two columns row by row So, this formula will return 600 as a value.
![compare two columns in excel and return a third value compare two columns in excel and return a third value](https://i.stack.imgur.com/Ffvyq.png)
To understand this formula, you have to know the syntax of IFERROR and VLOOKUP Excel functions. Input this formula in cell E2: =IFERROR(VLOOKUP(D2,project_manager,2,FALSE), “Not Assigned”) In cell D2, the Project coordinator might input a Project name and want to see who the Manager of the Project is. In the following spreadsheet, you are seeing a list of some Projects and their Managers. Further Readings 1) Compare two columns and return value from third column (using VLOOKUP formula)