Returning Multiple Results from a Vlookup

[Skaggs]

I am working on a project and I was wondering if it was possible in Excel to use the Vlookup formula to look up values and then add the multiple values together?

Example: I have in Column A a list of account numbers and in B1 I have 5.00, B2 6.00, and B3 4.00 is it possible to get 15.00 using the account numbers and the Vlookup?

The problem that I am having is that I am using the Vlookup and excel is returning only the first value. So how do I get excel to add the values together to get the final amount?
Because I have multiple account numbers that are the same and I would like to get the total of the account numbers.

Thanks.

 

[Cbrine]

Skaggs,
First welcome to the board.

Second, why not use a SumIF(), it will do exactly what you want.

Just list your accounts on a new sheet, and add this to column B.
=Sumif(CriteriaRange,A2,SumRange)

HTH
Cal