Forum Discussion
FBennie
May 23, 2023Copper Contributor
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 ...
HansVogelaar
May 23, 2023MVP
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.