Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    VLOOKUP - Need to add data from multiple sheets into one cell

    ✭✭✭
    in Formulas and Functions

    Hi,

    Question:

    How can I have the values of sheet 1 and sheet 2 go into 1 cell on sheet 3? I tried to just nest the same formula, as seen below:

    =VLOOKUP([Week Number]@row, {Calculation Sheet - Sheet 1 Range 6}, 3), VLOOKUP([Week Number]@row, {Calculation Sheet - Sheet 2 Range 2}, 2)

    Using the following formula successfully:

    =VLOOKUP([Week Number]@row, {Calculation Sheet - Sheet 1 Range 6}, 3)

    Result: 11

    Total Sheets: 3

    Sheet 1 value: 11

    Sheet 2 value: 9

    Master sheet: Total value in cell should be 20

    Should I even use a VLOOKUP? Thank you in advance!

    · Share on FacebookShare on Twitter

    Best Answers

    • Community Champion
      Answer ✓

      @MichSun

      It looks to me like you need to add a JOIN to the start of your formula. As you have it listed, there is not a prompt for the second half of your formula to return.

      Add the join at the beginning, and it should work for you.

      If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

      Always happy to work through questions or concerns!

      · Share on FacebookShare on Twitter
    • ✭✭✭
      Answer ✓

      Thank you Colleen - That did it!

      · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      Answer ✓

      @MichSun

      It looks to me like you need to add a JOIN to the start of your formula. As you have it listed, there is not a prompt for the second half of your formula to return.

      Add the join at the beginning, and it should work for you.

      If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

      Always happy to work through questions or concerns!

      · Share on FacebookShare on Twitter
    • ✭✭✭
      Answer ✓

      Thank you Colleen - That did it!

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions