giving me #Value!

  • Thread starter Thread starter Steved
  • Start date Start date
S

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
 
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
 
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","")
Click to expand...


=IF(AND(LEFT(A5,3)=LEFT(B5,3),LEFT(C5,3)=LEFT(D5,3)),"dup","")
 
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","")
 
Back
Top