vlookup and countif

[keexcel]

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.

 

[AhoyNC]

Maybe something like this:

Excel Workbook
	A	B	C	D	E	F
1	List 1				List 2
2	Dept.	permissions	Same as list two		Dept	permissions
3	Human Resources	Ability to Change profile	TRUE		Accounting	Ability to Change profile
4	Accounting	Ability to Change profile	TRUE		Finance	Ability to Change profile
5	Marketing	Ability to Change profile	TRUE		Marketing	Ability to Change profile
6	Finance	Ability to create profile	FALSE		Human Resources	Ability to Change profile
7	Production	Ability to Change profile	No Match
Sheet

 

[keexcel]

Thank you

Maybe something like this:

	A	B	C	D	E	F
List 1				List 2
Human Resources	Ability to Change profile		Accounting	Ability to Change profile
Accounting	Ability to Change profile		Finance	Ability to Change profile
Marketing	Ability to Change profile		Marketing	Ability to Change profile
Finance	Ability to create profile		Human Resources	Ability to Change profile
Production	Ability to Change profile

<colgroup><col style="width:30px; "><col style="width:161px;"><col style="width:184px;"><col style="width:184px;"><col style="width:41px;"><col style="width:136px;"><col style="width:177px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Dept.[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]permissions[/TD]
[TD="align: center"]Same as list two[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Dept[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]permissions[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]TRUE[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]TRUE[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]TRUE[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]FALSE[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]No Match[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula C3 =IFERROR(VLOOKUP($A3,$E$3:$F$6,2,0)=VLOOKUP(A3,A3:$B$6,2,0),"No Match") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thank you.

 

[keexcel]

Thank you.