giving me #Value!

[Steved]

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

 

[Jacob Skaria]

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)=LEFT(D5,3)),"Dup","")


If this post helps click Yes

 

[T. Valko]

There are many ways to interpret this so I'm using the logic of your
formula:

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

=IF(AND(LEFT(A5,3)=LEFT(B5,3),LEFT(C5,3)=LEFT(D5,3)),"dup","")

 

[Shane Devenshire]

Hi,

Your question is not clear. For one thing your formula and the stated
question don't match, there is no LEFT in your discussion.

Here is an array formula which MAY do what you are asking, if I interpret
your question correctly:

=IF(A5:B5=C55,"dup","")

array - this means that you must press Shift+Ctrl+Enter to enter the formula.

If the LEFT is really part of the question then use the following array
formula:

=IF(LEFT(A5:B5,3)=LEFT(C55,3),"dup","")

 

[Steved]

Hello to you all

I thankyou for taking timeout.