If, And, wildcard search

Originally Posted by Colin Legg

Hi,

You don't need the AND().

=IF(LEFT(B2,5)=LEFT(B3,5),"SAME","CONFLICT")

I was under the impression I needed the AND to do the nested if for the code column? I realize I didn't have any continuation of the formula in there, but that's where I need the help most! This is what I currently have:

=IF((LEFT(B2,5))=(LEFT(B3,5)),"SAME","CONFLICT")

and it is telling me if the previous entry is matching only in name. I need to add to the function, in order to find out if the code (Column C) matches as well.