title: Creating list and sublists in Excel
body: <p>I have a list of activities category that each activity in this list would be itself will be categorized and again each of this final activities link me to a specific number that I use that number in a function at Excel to find out my final answer.</p>
  
  <p>I'm looking for a solution to make this automated so when some one select their particular activity then they need to choose its sub-activities related to their choice (without displaying other activities) will be loaded and when they picked the one I will receive the specific code or number for that activity. 
  Also I do not know how can I define number for a text cell that when I select it gives me the number or code that has been defined for it.</p>
  
  <p>Example: I'm asking you select what you do during a week regard to workout and physical activity. you select the cell and choose for example bicycling and then you will be asked to be more specific, and you select another cell to choose ''biking 4mph to 7 mph''. </p>
  
  <p>The answers would be a number and that number will be placed in function in another cell and gives me the calorie that you burn during that specific activity.</p>
  
  <p>How can I create this formula? Your help would be greatly appreciated. </p>