giving me #Value!
 

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

giving me #Value!
 

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

giving me #Value!
 

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


--
Biff
Microsoft Excel MVP


"Steved" wrote in message
...
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

giving me #Value!
 

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=C5:D5,"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(C5:D5,3),"dup","")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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

giving me #Value!
 

Hello to you all

I thankyou for taking timeout.

"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