IF Formulas "containing" text

[janema]

I am having a complete mind blank, so turning to the experts here. This sounds like a a very long formula, but I thought I'd give it try. There is one section where it requires two criteria, so I'm not sure what order to write the formula. This is what I am trying to accomplish exactly (and I tried writing it out step by step like this, but keep getting an error):

If the cell O equals "Band 10 Target 70%", then "EXEC"
If the cell O equals "Band 13 Target 100%", then "EXEC"
If the cell O equals "Band 15 Target 125%", then "EXEC"
If the cell O equals "Band 8 Target 45%", then "EXEC"
If the cell O equals "Band 9 Target 50%", then "EXEC"
If the cell O equals "Band 9G Target 60%", then "EXEC"
If the cell O equals "Band 7 Target 40%", then "VP"
If the cell O equals "Band 2 Target 5%", then "Support"
If the cell O equals "Band 5 Target 20%", then "Dir"
If the cell O equals "Band 5S Target 0%", then "Dir"
If the cell O equals "Band 6 Target 30%", then "Sr. Dir"
If the cell O equals "Band 6S Target 0%", then "Sr. Dir"
If the cell O equals "Band 3 Target 10%", and cell K contains these words "Manager", then "Manager", otherwise, "Prof"
If the cell O equals "Band 3S Target 0%", and cell K contains these words "Manager", then "Manager", otherwise, "Prof"
If the cell O equals "Band 4 Target 15%", and cell K contains these words "Senior Manager", then "Sr. Mgr"
If the cell O equals "Band 4 Target 15%", and cell K contains these words "Associate Director", then "Assoc Dir"
If the cell Oequals "Band 4S Target 0%", and cell K contains these words "Senior Manager", then "Sr. Mgr"
If the cell O equals "Band 4S Target 0%", and cell K contains these words "Associate Director", then "Assoc Dir"

Is there a better way? LOL
I was thinking of using INDEX MATCH, but I hate how those formulas always get messed up when you sort or change anything.
Any thoughts would be be so much appreciated!

 

[awoohaw]

I'm not sure if MS expanded IF functions in the more recent editions. But, I believe you can only have 15 Nested IF levels.+
correction: It looks like you can have 64. Maybe it is 15 in VBA statements. I am at a loss now.

But, I don't understand your comments on INDEX MATCH. Generally your INDEX area would not be in a worksheet location that would be at risk of manipulation (If it is lookup table type of information).