Comparing text values in 2 Excel sheets Closed

Question

Greetings all,

I am looking to compare the text values in 2 Excel sheets and output them to a 3rd sheet.
Trying this in Excel 2010, and am a little rusty, not sure if I should use an "If" statement or a Vlookup function on this. The 1st sheet contains the master information, user ID's in column A (a2 and onward), and the applications they need in column B (b2 and onward). The second sheet contains the user ID's and the applications they have been assigned, in the same format. I would like to compare the 2 sheets, and have the differences (user ID's and applications not assigned), output to a 3rd sheet. Thanks in advance for any insight you can offer on this.

Mazzaropi · Answer

Good afternoon.

You can use both.
But it depends strictly about layout of your spreadsheet.

Please, to decide which solution is better, save your file at any free site and put the link here. You can use www . sendspace . com. 

Greetings from Brazil

MD763 · Answer

Mazzaropi,

Unfortunately, I cannot do that, as the used ID's are confidential company info, and I am blocked from sending the file to that site by company policy. Thanks for the help anyway.

Mazzaropi · Answer

We are not interested in your private data.
We are trying help you, as you asked.

Describe at least how are your layout with more details. 
Do it better than the previous description.

I believe that I can help you.

Comparing text values in 2 Excel sheets

3 responses

Similar discussions

Subscribe To Our Newsletter!