On Wed, 3 Dec 2008 16:45:02 -0800, sross002
wrote:

How would I look up a value in a list and return multiple corresponding
values and then add them up?

A B C
Paul 155 Pauk
Jake 34
Paul 145
Ann 222

=VLOOKUP(C1,$A$1:$B$4,2,TRUE))

Paul has two values that I would like to identify and add up.

Does anyone know of such a formula?

Thanks in advance.


Another option would be to use a Pivot Table.

Have titles for the two columns. e.g. Name | Value

Then Insert/Pivot table.
Drag Name to Row labels
Drag Value to Data or Value area
If the Value does not SUM, right click and select field settings and
change it to SUM
Format and Rename columns as you prefer.

You can get a report like:

Value Totals
Ann 222
Jake 34
Paul 300
Grand Total 556
--ron