Summing multiple VLOOKUP columns - Neat!

  • Thread starter Thread starter Mark Bigelow
  • Start date Start date
M

Mark Bigelow

I checked and didn't see a post about this before. My apologies if
there is one.

So, I have this lookup table and I needed to do the normal VLOOKUP
thing, except instead of returning just one column, I needed to return
the sum of multiple columns. I played around and came up with this,
which worked great:

{=SUM(VLOOKUP(A1&B1, $D1:$H900, {2,3,4,5}, FALSE))}

Entered as an array formula. I don't know if this is useful to
anybody, but I hope so!

Mark
Pacific Coast Feather Company
World's Best Down Comforters
 
Back
Top