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.