Compare Two columns If 2 cells are Matching

Question

My goal is to determine whether the values on E6 and F6 (when combined) coincide with those on B6 and C6 (together). For instance, the A column will be empty if (AA28E and 0.25) match the values on columns E and F, but it will add the string "d" otherwise.

Answer 1

Although I find it difficult to follow your question, I'll try. If you simply want to compare values within a single row and don't want to look at other rows, use the following syntax:

=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")