I think that is a good way to label what i am looking to do. I want to make a grocery list from a worksheet of drop down variables. Attached is the workbook. I would like to take the choices from Sheet 1 (4) and make a grocery list with the selected list/names of food choices and the total amounts needed to purchase on the Grocery List worksheet. What functions would I need to use since Sheet 1 (4) uses drop downs and attached amounts
I tried an =IF statement but it did not work. =IF('Sheet1 (4)'!B:B="chicken breast",'Sheet1 (4)'!C:C,0) was the staement used but I think it was wrong choice since I used vloopup on the meal planning sheet.
Bookmarks