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

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!

Best Answers

  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭
    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.

    Smartsheet Community Champion and Ambassador

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

  • MichSun
    MichSun ✭✭✭
    Answer ✓

    Thank you Colleen - That did it!

Answers

  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭
    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.

    Smartsheet Community Champion and Ambassador

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

  • MichSun
    MichSun ✭✭✭
    Answer ✓

    Thank you Colleen - That did it!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!