Vlookup best to check and lookup a pair of cells?

[dellfo]

Hi,

I would like to do a check on an employee and their line manager and check the employee and line manager are the same or are different from a previous month, however my excel command is flawed.

I would like it to check a pair of cells are the same as another pair of cells.
My current formula is
=IF(AND($C2=$A2, D2=B2), "Match", "False")

would a pivot table help?




note to self:
if the feb employee name = january employee name, lookup the january employee manager against the feb employee manager, if true "true" else "false"
pivot table

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(XLOOKUP(C2,$A$2:$A$100,$B$2:$B$100)=D2,"Match")

 

[dellfo]

Hi & welcome to MrExcel.
How about

=IF(XLOOKUP(C2,$A$2:$A$100,$B$2:$B$100)=D2,"Match")

Many thanks.
Seems to be working .... i'll check with a couple more sheets

 

[Fluff]

You're welcome & thanks for the feedback.