Forum Discussion
Orii120
Mar 31, 2019Copper Contributor
Help building a meal planner
Hey all, I'm looking for some help with a meal planner I'm trying to set up. I know how I want it to function however getting there is proving challenging. Sheet 2 (above) contains a...
Twifoo
Mar 31, 2019Silver Contributor
In Sheet1!D2, Enter this formula:
=VLOOKUP($B2,
Sheet2!$A:$E,
COLUMN(B1),0)
Then, you may copy the formula down rows and across columns.
=VLOOKUP($B2,
Sheet2!$A:$E,
COLUMN(B1),0)
Then, you may copy the formula down rows and across columns.
Twifoo
Mar 31, 2019Silver Contributor
The formula in Sheet1!D2 should be:
=$C2*
VLOOKUP($B2,
Sheet2!$A:$E,
COLUMN(B1),0)
I inadvertently forgot to multiply by $C2 in my earlier formula.
=$C2*
VLOOKUP($B2,
Sheet2!$A:$E,
COLUMN(B1),0)
I inadvertently forgot to multiply by $C2 in my earlier formula.
- Orii120Mar 31, 2019Copper Contributor
Twifoo
Hi there,Thanks for taking the time to help me out with this one. I really appreciate it.
I've tried using your formula however I can only seem to get it to use the data from the calories column even when the formula has been dragged into the other cells.
Any ideas?
Thanks
- TwifooMar 31, 2019Silver ContributorI don’t think so. In Sheet1!D2, COLUMN(B1) becomes COLUMN(C1) when copied to E2, COLUMN(D1) when copied to F2, and COLUMN(E1) when copied to G2.