Assigning values to a Validation Menu

A

AlwaysAAngel

I'm trying to do this thing on Excel where I have a list of values tha
are being summed at the bottom of the page. Thats not a problem. Th
problem I'm having is that one of the cells is a pull down lis
(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 i
with the rest of the sum. Anyone know how I can do this
 
D

Dave Peterson

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
 
Top