If statements using "AND" "OR"

I am trying to do an if statement that looks at two two cells and gives me a reference.

I have duplicate job numbers and in some cases one might be booked and one might be cancelled. I am trying to look at column a and determing if its a duplicate to the one above, If it si then I want to look at if it has a booked or cancelled status. This is what I tried.

=IF(AND(OR(A5=A4,W5="booked",W5="cancelled")),2)

Please help

Is this what you mean?

IF(A5=A4,IF(W5="booked","duplicate:booked",IF(W5="cancelled","duplicate:cancelled","duplicate:other status")),"")

check if A5 = A4. If not; result = empty.
If A5 = A4, then check and show the latest status.