Using vlookup to compare two excel files

For instance, employee ID, student roll number, customer contact number, seller email address, etc. You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution?

The corresponding match is a piece of information associated with the value being searched. Steps to compare two columns in excel using Vlookup are as follows. Here we discuss how to compare two columns and find matches in excel using VLOOKUP and wildcard characters along with examples and a downloadable excel template. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Stay tuned! We provide tips, how to guide and also provide Excel solutions to your business problems.

I earn a small commission if you buy any products using my affiliate links to Amazon. Contact Privacy Policy. Data Analysis with Excel Excel Formulas. Kawser Nov 10, 2. Table of Contents hide. Download Working File. Further Readings. Some more errors. Supposing, I have two worksheets with a list of names as following screenshots shown, now, I want to compare these two lists and find the matching names in Names-1 if they exit in Names It is painful to do such a comparison manually one by one between two sheets, this article, I will talk about some quick tricks to help you to finish it without effort.

Vlookup to compare two lists in separate worksheets with formulas. Vlookup to compare two lists in separate worksheets with Kutools for Excel. The following formula can help you to extract the names both in Names-1 and Names-2 sheets, please do as this:.

Then drag the fill handle down to the cells to return the names both in Names-1 and Names-2 sheets, see screenshot:. In the above formulas: A2 is the first cell of the worksheet that you want to compare, Names-2 is another worksheet name that you want to compare, A2:A19 is the name column to be compared with.

Click to download Kutools for Excel! Kutools for Excel : with more than handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now! After installing Kutools for Excel , please do as follows:. Select the data list in Names-1 sheet under the Find values in , and then select the data from Names-2 sheet under the According to ;.

Check Each row from the Based on section;. Choose Same Values from the Find section;. Then you can choose background color or font color for the same names which are in both sheets as you need.