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.