Assigning values to a Validation Menu

I'm trying to do this thing on Excel where I have a list of values that are being summed at the bottom of the page. Thats not a problem. The problem I'm having is that one of the cells is a pull down list (Validation) and I need to set it up so each of the choices (eg. A-1, B-2,...) has a specific value associated with it that will be added in with the rest of the sum. Anyone know how I can do this?

A-1
B-2
are not cell addresses (A1 or B1), are they?

And if you have quite a few of these, it might be best to set up a table (on
another worksheet) that has the values that correspond to these choices.

A-1 5
B-2 17
c-3 39
'etc

Then you can use =vlookup() in a nice adjacent cell (or embedded into the
formula) to return that value:

=if(c9="",0,vlookup(c9,sheet2!a:b,2,false))
(C9 is my cell with data|validation.)

Then you can use:
=sum(c2:c8,d9,c10:c99)

to add them up.
(c2:c8 & c10:c99 are just numbers, d9 held that =vlookup() formula)

For more info about =vlookup()...
You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html

AlwaysAAngel wrote:
>
> I'm trying to do this thing on Excel where I have a list of values that
> are being summed at the bottom of the page. Thats not a problem. The
> problem I'm having is that one of the cells is a pull down list
> (Validation) and I need to set it up so each of the choices (eg. A-1,
> B-2,...) has a specific value associated with it that will be added in
> with the rest of the sum. Anyone know how I can do this?
>
> --
> AlwaysAAngel
> ------------------------------------------------------------------------
> AlwaysAAngel's Profile: http://www.excelforum.com/member.php...o&userid=27284
> View this thread: http://www.excelforum.com/showthread...hreadid=467915

--

Dave Peterson