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