Hi!

Try one of these:

=IF(OR(A1="",A2=""),"",(MATCH(A1,{"Terrible","Poor ","Excellent"},0)-1)*(MATCH(A2,{"Terrible","Poor","Excellent"},0)-1))

=IF(OR(A1="",A2=""),"",VLOOKUP(A1,{"Terrible",0;"P oor",1;"Excellent",2},2,0)*VLOOKUP(A2,{"Terrible", 0;"Poor",1;"Excellent",2},2,0))

Biff

"EyeNoNothing" <u18483@uwe wrote in message news:5b8111f649bcb@uwe...
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...