How to compare two columns and return values from the third column in excel?



How to compare two columns and return values from the third column in excel?..

Answer / Chaudhary Ravi

"To compare two columns and return values from the third column in Excel, you can use an IF statement. Here's an example:nnIF(A2 = B2, C2, "Not equal") will compare cell A2 with cell B2 and return the value of cell C2 if they are equal, otherwise it will return 'Not equal'."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you fix a cell value in excel?

1 Answers  


How do you delete a row?

1 Answers  


How do you combine names in excel with commas?

1 Answers  


How do you find the mode on excel?

1 Answers  


Is excel in windows 10?

1 Answers  


How do I merge cells in an excel table?

1 Answers  


Can I use sumif with multiple criteria?

1 Answers  


What is the definition of problem solver?

1 Answers  


How do I write a formula in excel?

1 Answers  


How do you check formulas?

1 Answers  


How do I change text format to number format in excel?

1 Answers  


How do I create a scenario in excel 2016?

1 Answers  


Categories