Compare columns a and b match columns c and d

[kristell]

Hello - please can you help. I have two lists of employees and their job titles and need to find those that do not match as they have changed jobs.
So column A = name Column B = Job Title

column d = name and column D = Job title

I need to find those where the name is the same but the job title is different.

e.g.

Name	Job Title	Name	Job Title
John Smith	Officer	John Smith	Officer	Match
Deborah Jones	Clerk	Deborah Jones	Receptionist	No match
Fred Clark	Manager	Fred Clark	Manager	Match

Thank you if you can help me with either conditional formatting or some other method.

 

[Fluff]

What version of Excel are you suing?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

+Fluff 1.xlsm
	A	B	C	D	E
1	Name	Job Title	Name	Job Title
2	John Smith	Officer	John Smith	Officer	Match
3	Deborah Jones	Clerk	Deborah Jones	Receptionist	No match
4	Fred Clark	Manager	Fred Clark	Manager	Match
Lists

Cell Formulas
Range	Formula
E2:E4	E2	=IF(VLOOKUP(C2,A2:B4,2,0)=D2,"Match","No match")

 

[kristell]

Thanks - I will update my details and try your suggestion. I appreciate your help thank you.

 

[Fluff]

Ok