If cell A has specific words in it, I want cell B to equal a certain set of words.

ie.

if I enter in Cell A: Audio Productions Group
then I want cell B: ASCAP (100%)


This is a form that I have to fill out that has several different combinations of words that will always require their partner value in the next cell. I want to reduce input time by being able to type in one text value, and have the other cell type the corresponding words.


If that is possible, then I am curious as to whether I can take it a step further.

ie.

Cell A: ABC1234_random words

the "ABC" at the beginning of that strand will always be the same for this situation, but the numbers and the words afterward will change. Can I get cell B to recognize that anytime it sees "ABC" as the first 3 characters, it will type in "Audio Productions Group"? And if that works, then I can make cell C type in "ASCAP (100%)" every time is sees that cell B is "Audio Productions Group".

Thank you


I am using excel 2011