How do I match data in two columns in excel?



How do I match data in two columns in excel?..

Answer / Alok Naudiyal

To match data in two columns, select the column you want to use as a reference, then go to 'Formulas', 'Fill', and choose 'Horizontal' or 'Vertical' depending on your requirement.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is the best excel training course?

1 Answers  


How do I enlarge the view in excel?

1 Answers  


How do I concatenate a range of cells in excel with a comma?

1 Answers  


How do I paste an excel table into word and fit it?

1 Answers  


How do you merge two rows in excel?

1 Answers  


What are the types of validation?

1 Answers  


What is excel used for?

1 Answers  


How do I unhide all tabs in excel?

1 Answers  


What are the benefits of using database functions excel?

1 Answers  


How do I run a macro every time a certain cell changes its value?

1 Answers  


I have saved my workbook with a password, but excel does not recognize it and would not let me open the file. Am I out of luck?

1 Answers  


How do you use the sumifs function in excel?

1 Answers  


Categories