This is probably pretty basic, but I've been struggling with constructing (what according to internet examples is) a pretty simple function. I want to construct a dependent drop down list to allow selection of foods from various food group tables. Independent food group tables have been constructed for each (Fruit, Vegetable, etc.) food group. Tables are each defined as 'tables' in Excel, and are (single word) named. Additionally, a separate ('FoodGroup') table is constructed listing the 'names' of the various food tables. These tables are maintained on an unique ('Data Tables') sheet in the workbook. I want to 'pull' individual food information from the data tables into a ('Calorie Calculator') spreadsheet.
Simplistic internet examples indicate that dropdown lists and dependent dropdown lists may be constructed with direct reference to established 'tables' by 'table name'. Using 'Data Validation' and,
The above result (e.g., 'Fruit') is stored on the 'Calorie Calculator' sheed in cell B16. I've attempted to construct the dependent drop down list using the result by,
Thanks
Simplistic internet examples indicate that dropdown lists and dependent dropdown lists may be constructed with direct reference to established 'tables' by 'table name'. Using 'Data Validation' and,
- Setting Allow: 'List' and Source: 'FoodGroups' results in a list containing the single item 'FoodGroups',
- Setting Allow: 'List' and Source: '"FoodGroups"'results in a list containing the single item '"FoodGroups'",
- Setting Allow: 'List' and Source: '=Foodgroups' results in error (The forumla you typed contains an error...),
- Setting Allow: 'List' and Source: '="FoodGroups"' results in error (The list source must be a delimited list, or a reference to single row or column.),
- Setting Allow: 'List' and Source: '=INDIRECT("FoodGroups"' seems to provide the desired list. This seems inconsistent with my understanding of the 'INDIRECT' function.
The above result (e.g., 'Fruit') is stored on the 'Calorie Calculator' sheed in cell B16. I've attempted to construct the dependent drop down list using the result by,
- Setting Allow: 'List' and Source: '=INDIRECT($B$16)'.
Thanks