**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula to compare If column A&B are = to column E&F then enter True or False

Solved by M. H. in 12 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
10/04/2018 - 07:18

Hello!

Excelchat Expert
10/04/2018 - 07:18

welcome to excelchat!

User
10/04/2018 - 07:18

Hello

Excelchat Expert
10/04/2018 - 07:18

you want to compare a with e and b with f right?

User
10/04/2018 - 07:19

right

Excelchat Expert
10/04/2018 - 07:20

ok sure

Excelchat Expert
10/04/2018 - 07:20

please check cell c1

Excelchat Expert
10/04/2018 - 07:20

type values in a b e and f

Excelchat Expert
10/04/2018 - 07:21

there?

Excelchat Expert
10/04/2018 - 07:21

it will say true if a is equal to e and b is equal to f

Excelchat Expert
10/04/2018 - 07:21

if any one is not equal it will show false right?

User
10/04/2018 - 07:22

for example......

Excelchat Expert
10/04/2018 - 07:22

check if c1 is working

Excelchat Expert
10/04/2018 - 07:23

as per your requirement or not by changing values in a1 b1 e1 and f1

Excelchat Expert
10/04/2018 - 07:23

in preview sheet beside you

User
10/04/2018 - 07:23

A has social security numbers and B has payroll deductions and E and F have the same information but there is discrepancies in the deduction amounts in B and F

Excelchat Expert
10/04/2018 - 07:24

then it should say false right?

User
10/04/2018 - 07:24

correct

User
10/04/2018 - 07:24

It says content cannot be displayed

Excelchat Expert
10/04/2018 - 07:24

=IF(A1&B1=E1&F1,"true","false")

User
10/04/2018 - 07:24

in the open window

Excelchat Expert
10/04/2018 - 07:24

this is the formula

Excelchat Expert
10/04/2018 - 07:24

try this

User
10/04/2018 - 07:25

ok

Excelchat Expert
10/04/2018 - 07:25

and let me know if its working as per your requirement or not

User
10/04/2018 - 07:29

I believe this works

User
10/04/2018 - 07:29

amazing Thanks

Excelchat Expert
10/04/2018 - 07:29

ok do you need further help regarding this issue?

Excelchat Expert
10/04/2018 - 07:29

pleasure

User
10/04/2018 - 07:30

So just so I'm clear this identifies discrepancies in A&B if they don't match E&F?

Excelchat Expert
10/04/2018 - 07:30

yes for sure

Excelchat Expert
10/04/2018 - 07:30

this will

User
10/04/2018 - 07:30

ok that will be it. Thanks a bunch

Excelchat Expert
10/04/2018 - 07:30

thank you for choosing excelchat!

Excelchat Expert
10/04/2018 - 07:30

please end this session from your side thanks!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*