How to Add Multiple VLOOKUPs with Multiple Columns in Google Sheets

1
votes

I have multiple sections with the same name appearing in these sections. Along with each name is an entire row with different values. I'm looking to add the B column with the other section's B column corresponding to the same person. Then C with C, and so on until Z. In the end, I want one final row, adding all the other rows together.

With my current code, only the first column is added together. The other columns get ignored.

Note: This is for Google Sheets.

=ArrayFormula(VLOOKUP("Doe, John",A16:Z35,{2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26},false))+ArrayFormula(VLOOKUP("Doe, John",A42:Z61,{2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26},false))
1
arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
docs.google.com/spreadsheets/d/… - Jhine7
Row 286. Thank you. Will need to change name however. Fall Season tab. - Jhine7

1 Answers

1
votes

do it like this:

=ARRAYFORMULA(
 VLOOKUP("Doe, John", A16:Z35, {2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26}, 0)+
 VLOOKUP("Doe, John", A42:Z61, {2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26}, 0))

0

btw, you could do it shorter like: 

=ARRAYFORMULA(
 VLOOKUP("Standera, Thomas", A16:Z35, COLUMN(B:Z), 0)+ 
 VLOOKUP("Standera, Thomas", A42:Z61, COLUMN(B:Z), 0))