hi

I have a drop down list starting at column S2 that contains two values


Duplicate
Master

Depending on the selection, I want a message to appear in V2

I have this formula currently in V2...

=IF(AND(U2=A2,S2="Duplicate")," Master Account Cannot be a duplicate of
itself ", " ")

However, I want to add another part to this, ie

=IF(S2="Master"," Master Account Not req ", " ")

I've tried lots of different ways to turn both formulas into one, but
cannot seem to work it out


Thanks in advance