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

MichSun

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!

Colleen Patterson

@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.