Hello, the solution you provided should be working for me but it's not. Here is what I'm trying to do:

I’m trying to figure out how to say: If Column W contains the word felony, put felony in Column X. If Column W contains the word “misdemeanor,” put “misdemeanor” in Column X. But if Column V contains “VOP,” then Column X should say “VOP”. In other words, VOP trumps misdemeanor, but not felony.

At first, I used the following function, but it's not working:

=IF(ISNUMBER(SEARCH("felony",W2,1)),"felony",IF(ISNUMBER(SEARCH("misdemeanor",W2,1)),"misdemeanor",IF(ISNUMBER(SEARCH("Probation",V2,1)),"VOP","")))

The problem seems to be that I'm pulling felony and misdemeanor information from Column W but Probation from Column V.

So I tried the following AND statement:
=IF(AND(ISNUMBER(SEARCH("Probation",V2)), ISNUMBER(SEARCH("misdemeanor",W2))), "VOP","")

But my understanding is that if probation is in V2 and misdemeanor is in W2, then VOP should appear. However, it turns up blank. When I reverse "VOP","" to "","VOP" - then VOP appears. But this AND formula does not give me my felony information.

Can you please help? Thanks.