Find + if + lookup

I'm sorting through a list of business executives and trying to classify them by their titles to sort them into functional areas, but I'm ending up having to use just a giant nested IF statement, and there has to be a better way of doing it.

Not everyone has a uniform title, so I'm using FIND to look at the title and find particular search strings. Basically it's this, over and over again:

=IF(ISNUMBER(FIND("Operation",A1)),"Operations/Manufacturing",

Where the title is obviously in A1. I can easily assemble a VLOOKUP table, but I don't know how to combine this with the ISNUMBER(FIND aspect of this.

Can anybody help?