Ok, I have set up the cells in a column (H) to analyze the phrase in column
(G) and give a value. H2=IF(G2="PHRASE1",Val.1,IF(G2="PHRASE2",Val.2,0)) . Now
I have done this for eight individual phrases and values. What I want to know
is....

1) Is there a way for me to input a quantity of phrase and have H give me
the product? EX( 2,Phrase1= 2 x Val.1).

2) Is there a way to input multiple phrases and quantities?
(2,Phrase1,1,Phrase2 = 2 x Val.1 + 1 x Val.2)?