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.
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.