# Excel Formula needed

February 21, 2009 at 10:57:27
Specs: Windows XP
 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 TotalsJack 1 2 3 CalculateMark 2 3 4 CalculateDave 3 1 1 CalculateTom 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 TotalsJack 1 2 3 24Mark 2 3 4 19Dave 3 1 1 26Tom 4 4 2 18Thanks,Jenn

See More: Excel Formula needed

#1
February 21, 2009 at 15:11:41
 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.

Report •

#2
February 22, 2009 at 21:41:59
 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 TotalsJack---1-----2-----3----24Mark---2-----4----------13Dave---------3-----1----16Tom----------------2-----8-Jenn

Report •

Related Solutions