Compare two lists with two variables

[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

 

[KL]

Hi John,

How about this ARRAY formula (Ctrl+Shift+Enter):

=AND(A2:B2=C22)

Regards,
KL

 

[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
-----------------

 

[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

 

[Biff]

Hi!

Try this:

=A2&B2=C2&D2

Biff