Forum Discussion
Drop Down List
I am trying to create a workbook that does caloric calculations, I know how to make a drop-down list but it needs to link to numerical values so that It links into a formula the values are below
Select = 0
Mostly Inactive or Sedentary = 1.2
Fairly Active = 1.3
Moderately Active = 1.4
Active = 1.5
Very Active = 1.7
Enter the text values and corresponding numbers in a range:
Select 0 Mostly Inactive or Sedentary 1.2 Fairly Active 1.3 Moderately Active 1.4 Active 1.5 Very Active 1.7 Select this range, then click in the name box on the left hand side of the formula bar.
Enter a name, for example Choices, and press Enter.
Let's say that the cell with the drop down is D2.
You can then use VLOOKUP(D2, Choices, 2, FALSE) in a formula; this will return the number associated with the item selected in the drop down.
