Associated Numerical Values

[kdoggity]

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?

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kdoggity" <[email protected]> wrote in message
news:[email protected]...
> 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?

[kdoggity]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kdoggity" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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?
> >
> >
> >