Forum Discussion
What Formula to use to pull data from drop down list?
You need something like in the file attached.
You insert data in the DATA sheet (obv). Be careful to not switch columns.
Then, when you need to check numbers, use the CHECK sheet.
Select from the dropdown menu (that you need to update -data, validate cell, list, select the new interval) the dish you want, it shows you aside the values from DATA. You also need to update sheet CHECK if you add more receipes (to get all cells in the formula).
On the top of the page, it sums all the datas from the dishes you chose and alerts you if something is wrong.
Do not delete data from grey cells and do not erase rows even if you're seeing it blank.
You need something like in the file attached.
You insert data in the DATA sheet (obv). Be careful to not switch columns.
Then, when you need to check numbers, use the CHECK sheet.
Select from the dropdown menu (that you need to update -data, validate cell, list, select the new interval) the dish you want, it shows you aside the values from DATA. You also need to update sheet CHECK if you add more receipes (to get all cells in the formula).
On the top of the page, it sums all the datas from the dishes you chose and alerts you if something is wrong.
Do not delete data from grey cells and do not erase rows even if you're seeing it blank.
Arul,
Thank you so much for the quick response. That is exactly what I am trying to do. This will make it easier to create my daily planning. Again thank you so much. ~Steve
