Summing multiple VLOOKUP columns - Neat!

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top