ExcelBanter - Value of drop-down list

First right out the list that you use for the drop down list... then
highlight it and give it a name. Then get the drop down list. Go to "Format
Control"

In the control menu, under "Input Range"--- Input the name you created for
the list.

Then in the cell link box, select a cell where you want the number to
appear. Best to put it next to the named range.

So go back to the list you created next to the list insert the value you
want, such as 1 next to month or whatever you want the value to do.

The cell link is based on the list in order. So the first name in the list
is 1 and so on. So when you choose the 3rd Item in the list the cell link
well show 3.

So when you put the values next to the items... in the cell where you want
the value to show up based on your selection input the formula.

=OFFSET("Start of Named Range","Cell Link",1)

To break this down.

Start of Named Range is the top of the List you created
For Example

Items
Weekly
Monthly
etc

In this example... Items would be the start of the named range.

Cell link is the cell where you inputed the cell link. This is the row
number. So if you select monthly in the drop down list, the cell link well
show 2 and the offset function well bring the selection down 2 rows from
Items. So it lands on Monthly.

The 1 is column number. 1 Column over from the starting point ("Items") is
where you input the value for the items list.

Hopefully this was clear enough, let me know if you need anything else.
"agladish" wrote:

How do I assign a value to an item in a drop-down list i n Excel? I need a
value to an item, such as "weekly", "monthly", etc., that will be used to
calculate other data in other cells.