Multiple VLOOKUP in One Cell?

[mushman1]

Hello-

I need one cell to lookup values from two sources and return a summed value. As an example:

Cell B2 is going to vlookup values from cells B3, B4, and B5 and return results that are pulled a table and then add them.

Kind of hard to explain so I hope this makes sense. Basically, a vLoopup that looks up from 3 cells instead of 1 and adds the results (which are #s).

Thoughts? Thanks.

[martindwilson]

sumproduct will probably work or combined index
post a work book

[MrBill]

Hello- Thanks for the help. I've attached a basic file.

Thanks again.

[martindwilson]

=sumif(c10:c19,c4,d10:d19)+sumif(c10:c19,c5,d10:d19)+sumif(c10:c19,c6,d10:d19)

[MrBill]

Super. Totally works. Many thanks!