as a kid i thought i would graduate from kid problems like cleaning my room to adult problems like jobs and taxes. but instead i have a job and taxes and still have to clean my room. cleaning my room is a lifetime problem. i will never stop having to put my markers away before bedtime. this is a rude way for aging to work.
I DID IT IN GOOGLE'S EXCEL BC THAT'S WHAT I HAVE ACCESS TO ON MY PERSONAL DEVICE. I IMAGINE EXCEL EXCEL IS PROB SIMILAR.
column A: name of the dishes you want/know how to make
column B: ALL of the ingredients for each dish
put FILTER formula in E2. literally type it the exact way you see it here. the only adjustment you'll need to make is B16 and A$16, because you'll need to adjust those for however many rows you have in columns A and B. for example: if you have 100 rows total, you'll need the formula to read =FILTER(B1:B100,D2=A1:A$100). now enter the value (the name of your dish) in D2 to test it out. if you type the name of one of your dishes and it returns ingredients, congrats! you did it.
to make a dropdown list, select the cell you want your dropdown list you want to be in then:
go to Data, and select "Data validation"
click + Add rule
then it'll let you add dropdown options
enter the names from Column A, and bam! you got a dropdown that'll return ingredients!
to make lunch/dinner/etc, use the same =FILTER(B1:B100,D2=A1:A$100), and all you'll be changing is the D2. instead of D2, just put the name of the cell where you'll be putting your dropdown for the meal.
so for mine
Lunch is =FILTER(B1:B100,F2=A1:A$100)
and
Dinner is =FILTER(B1:B100,H2=A1:A$100)
voila, my friends! you now have a drop down mealplanner that'll autopopulate ingredients
ENJOY NOT HAVING TO MEALPLAN OR WRITE GROCERY LISTS FROM SCRATCH EVER AGAIN OKAY BYE
A cunning vampire door-to-door salesperson who stands in people’s doorways and talks until they can find a convenient moment to drop their pen and the person picks it up and the vampire says oh “Thank you” and the person says “you’re welcome” and the vampire smiles a big fangy grin and steps inside And that’s this vampire’s modus operandi for decades And then the language starts to change and suddenly millenials have homes and the vampire thanks them and they say “oh, no problem” and the vampire is like ???????????????? this was not the plan
We live in constant fear of the short ones, who (in my experience) will climb 4 chairs, 2 boxes, a small coffee table, and 6 oddly placed stools to get what they want