Excel Formula to check values in two columns.
Use case: columns E1 and I1 can have any number. If values are 5 or 6 or 7 in both columns then I should get matched else notMatched.
=IF(AND(IF(OR(E1={5,6,7}), 1,0),IF(OR(I1={5,6,7}), 1,0)),"matched","notMatched")
