I'm trying to create a formula that references two cells. In each of the
cells is a drop down box with three options. The options aren't numbers. Is
there a way to associate values to those options so that the formula will
result in a numerical total?

=MATCH(A1,{"a","b","c"},0)+MATCH(A2,{"x","y","z"}, 0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kdoggity" wrote in message
...
I'm trying to create a formula that references two cells. In each of the
cells is a drop down box with three options. The options aren't numbers.
Is
there a way to associate values to those options so that the formula will
result in a numerical total?

that's not working. perhaps I'm not entering it correctly. I'll tell you
what I've got. Cell D5 has a drop down with A,B,C. Cell E5 has a drop down
with the same thing, A,B,C. I want A to equal 15, B to equal 20, and C to
equal 30. I want Cell F5 to equal the sum of D5, and E5. Is that possible?
Thanks!

"Bob Phillips" wrote:

=MATCH(A1,{"a","b","c"},0)+MATCH(A2,{"x","y","z"}, 0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kdoggity" wrote in message
...
I'm trying to create a formula that references two cells. In each of the
cells is a drop down box with three options. The options aren't numbers.
Is
there a way to associate values to those options so that the formula will
result in a numerical total?

=VLOOKUP(A1,{"A",15;"B",20;"C",30},2,FALSE)+VLOOKU P(A2,{"A",15;"B",20;"C",30
},2,FALSE)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kdoggity" wrote in message
...
that's not working. perhaps I'm not entering it correctly. I'll tell you
what I've got. Cell D5 has a drop down with A,B,C. Cell E5 has a drop
down
with the same thing, A,B,C. I want A to equal 15, B to equal 20, and C to
equal 30. I want Cell F5 to equal the sum of D5, and E5. Is that
possible?
Thanks!

"Bob Phillips" wrote:

=MATCH(A1,{"a","b","c"},0)+MATCH(A2,{"x","y","z"}, 0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kdoggity" wrote in message
...
I'm trying to create a formula that references two cells. In each of
the
cells is a drop down box with three options. The options aren't
numbers.
Is
there a way to associate values to those options so that the formula
will
result in a numerical total?