I'm trying to compare two list. I have two list that have the same type of data, but they are from different sources. Both files have a list of departments and the permissions each department has. I need to lookup a department name and determine if that dept has a permission listed next to it. Example of data (note this is the same layout in both files):
Human Resources Ability to Change profile
Accounting Ability to Change profile
Marketing Ability to Change profile
Finance Ability to create profile
Second file may have all of the same departments, but not list all of the same permissions. How can I determine if a permissions exist for a specific department in both files? I was trying to use vlookup and countif together, but I have not been able to figure it out.
Human Resources Ability to Change profile
Accounting Ability to Change profile
Marketing Ability to Change profile
Finance Ability to create profile
Second file may have all of the same departments, but not list all of the same permissions. How can I determine if a permissions exist for a specific department in both files? I was trying to use vlookup and countif together, but I have not been able to figure it out.