I'm putting together a workbook that helps create a grocery list. There are 3 worksheets. The first worksheet (call it "meals") has a drop down box in cell A1 which lists all of the possible meals available by name. In cell B1 of "meals", you can choose if you would like the meal to be 300, 400 or 500 calories. The second worksheet (call it "ingredients") has all of the meals listed in column A, with the corresponding calories of 300, 400, 500 listed in Column B. Column C has the ingredients. What I'm trying to do is create a formula in the third worksheet (call it "grocery list") that finds what meal you have selected (cell A1 in worksheet "meals") and how many calories you would like that to be (cell B1 in worksheet 'meals") and it searches worksheet "ingredients" for an exact match. So it searches column A of worksheet "ingredients" to find the matching meal that was picked in cell A1 in worksheet "meals". Next, it takes how many calories you chose in cell B2 of worksheet "meals" and it finds that match in column B of worksheet "ingredients". Once it has matched the meal and calories, it copies the ingredients that are listed in column C to worksheet "grocery list".
Is this possible without Visual Basic? or some other programming stuff?
Bookmarks