How to make cell values equal certain text depending on other cells' text

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

Hi , enter in cell C =ASCAP (100%) or cell A =ABC1234_random words ,will trigger cell B update to Audio Productions Group ? is that Effect ?

would you upload a exmples for us to review what you want ?

Fotis that is perfect!!

So that I might become a little bit more proficient, can you tell me what <> and double quotations "" do?

Thank you again very much