Checking for Matching Data in Two Columns

[damccart]

I'm needing to create a formula to check two columns. I'm needing to check following...

if the first column has an A, then the second column should have a 1 or 2;
if the first column has a B, then the second column should have a 2 or 4;
if the first column has a C, then the second column should have a 4.

I don't care if its done through conditional formatting and for example something turns red if they don't match or it can be a formula that returns a 0 if they don't and a 100 if they do.

 

[Joe4]

Welcome to the Board!

Try this formula (for row 1 entries):

=IF(OR(AND(A1="A",OR(B1=1,B1=2)),AND(A1="B",OR(B1=2,B1=4)),AND(A1="C",B1=4)),100,0)

 

[damccart]

Perfect! That worked. Thanks so much.

 

[Joe4]

You are welcome!