Forum Discussion

Orii120's avatar
Orii120
Copper Contributor
Mar 31, 2019

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...
excel
Twifoo's avatar
Twifoo
Silver Contributor
Mar 31, 2019
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.
Twifoo's avatar
Twifoo
Silver Contributor
Mar 31, 2019
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.
  • Orii120's avatar
    Orii120
    Copper Contributor
    Mar 31, 2019

    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

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Mar 31, 2019
      I 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.

Resources