As per your description the below should work

=IF(AND(A5<"",A5=C5,B5=D5),"Dup","")

If you are looking at the left 3 then add left for each cell reference in
the above formula

=IF(AND(A5<"",LEFT(A5,3)=LEFT(C5,3),LEFT(B5,3)=LE FT(D5,3)),"Dup","")


If this post helps click Yes
---------------
Jacob Skaria


"Steved" wrote:

Hello from Steved

If A5 and B5 is The Same as C5 and D5 then display "dup" please

=IF(LEFT(A5,3)=LEFT(b5,3),"dup","")+=IF(LEFT(c5,3) =LEFT(d5,3),"dup","")

Thankyou