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.