HI I am trying to create a formula in excel.

I need to have the value in one column look up the value in a second column and then enter the corresponding value from a third column. It then needs to add up three of these columns together and return a result.Race1 Race2 Race3 Totals

Jack 1 2 3 Calculate

Mark 2 3 4 Calculate

Dave 3 1 1 Calculate

Tom 4 4 2 CalculateIn a separate worksheet would be the values.

Position Points

1 10

2 8

3 6

4 5

5 4

6 3

7 2

8 1So in the original spreadsheet if position equals 1 that corresponds to 10 points. I'm looking to take the values in the position columns, correspond it to the value in the points column, add them all together and return a result...

Race1 Race2 Race3 Totals

Jack 1 2 3 24

Mark 2 3 4 19

Dave 3 1 1 26

Tom 4 4 2 18Thanks,

Jenn

What kind of racing are you keeping track of? Here's one way. Look at the Help files for VLOOKUP to see how it works.

Let's put your Race Results example in Sheet1!A1:D4.

Let's put your Points Table in Sheet2!A1:B8.

In Sheet1:E1 enter this formula and drag it down to E4:

=SUM(VLOOKUP(B1,Sheet2!$A$1:$B$8,2,0),VLOOKUP(C1,Sheet2!$A$1:$B$8,2,0),VLOOKUP(D1,Sheet2!$A$1:$B$8,2,0))

That formula gave me the results you showed in your example.

Hi Thank you.

We run go kart races and I'm trying to keep track of the points. Sometimes the tracks are not accurate.

Anyway, this works, but only for the columns that have all races filled out. What if I have a racer who didn't compete in a race so therefore does not have a result?Name Race1 Race2 Race3 Totals

Jack---1-----2-----3----24

Mark---2-----4----------13

Dave---------3-----1----16

Tom----------------2-----8-Jenn

Ask Your Question

Weekly Poll

Do you think Google Fiber has a strong future?

Discuss in The Lounge

Poll History