i want to be able to use the vlookup function and pull values to total them. The problem I am having is this:


In the vlookup formula the value that I want to look up is sometimes used multiple times within the range.

Bob 12 14 16
Tim 22 33 45
Tom 34 45 76
Bob 85 35 35

If I want to lookup "Bob" from column 2 and total the values - how do i write the formula?

THANKS!!!