I don't think there's an ELSE, so you have to nest:
=IF(AND(A1=A2,A3="Duplicate"),"One",IF(A3="Master" ,"Two",""))

Lisa wrote:
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