Compare Two columns If 2 cells are Matching-CodePudding

My intention is to check if the value on E6 and F6(together) are matching the values on B6 and C6(together). For ex. if (AA28E and 0.25) is matching with the values on column E and F, the A column will be blank otherwise it will add "d" string.

How should I correct the formula ?

CodePudding user response：

I think your question is hard to follow but I'll give it a shot. If you only want to compare values with in the single row use and not look at a different row use:

=IF(AND(B3=D3,C3=E3),"","d")

If want to know if the values in one row of E&F match exactly the rows of columns B&C use COUNTIFS().

=IF(COUNTIFS(B:B,D3,C:C,E3)>0,"","d")

CodePudding user response：

Haven't tried this in Excel recently, but should work according to your comments to the previous answers.

=IFERROR(IF(MATCH(1,(D:D=B1)*(E:E=C1),0), ""), "d")

CodePudding user response：

=IF(AND(E6=B6,F6=C6),"","d")