Hi everyone,

I'm kind of in a bind here, and I'm trying to figure out how to do this in
Excel.

Basically, what I want to do, is I want to create a drop down list that
provides Text, but assignes the text a numiercal value to be used in another
formula.

Example.

The drop down list contains the following in A1 and in A2:
Excellent
Poor
Terrible

I need Excellent to have a value of 2, Poor to have a value of 1, and
Terrible to have a value of 0

So in Cell A3, I can have the formula =A1*A2 and it will give me a numerical
value.

Can this be done? If so how, cause I am stumpted...