Returning Multiple Results from a Vlookup

Skaggs

New Member
Joined
Dec 16, 2005
Messages
14
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.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,286
Messages
5,571,313
Members
412,382
Latest member
Langtn02
Top