Compare two lists with two variables

J

John

If I wanted to check that the Surname AND the Firstnames were the same
in each of four columns,
what changes would I make? Ideally I would wwish that the output was as
below:-

Column A Column B Column C Column D
Surname Forename Common entry Surname Common entry Forname

Wilson Bob Wilson
Bob



Jonah
 
J

John

I am not sure what this tells me. Please can you explain the
(Ctrl+Shift+Enter) and where do I put the formula?

John
-----------------
 
K

KL

This will give you TRUE if the pairs are identical and FALSE if they are
not. "Ctrl+Shift+Enter" hasn't more explanation than that it is necessary
with (some) array formulas (formulas that operate with arrays, not single
values).

Regards,
KL
 
Top