Nested fuctions and Vlookup

For the case found here we can use nested formulas like =IF(B11>=B6,SUM(C2:C6),IF(B11>=B5,SUM(C2:C5),IF(B11>=B4,SUM(C2:C4),IF(B11>=B3,SUM(C2:C3),IF(B11>=B2,SUM(C2),IF(B11>=0,0,0)))))) . It looks complicated but if you havve a look at it it is not. It just repeats itself. The first part says that if the amount of homeruns is equal or bigger than 60, he will get 1000000 (the sum of C2:C4) and if not it would look if it is bigger orequal to 50 and so on...
For the vlookup you can convert first the range into a table to make it easier. You have to add a third column to the table with the cumulative amounts. After you did that you just need to enter the formule =VLOOKUP(B11,table1,3 where B11 is the lookup data and table1 is the name of the table where it should lookup and 3represents the column of the table where to look ti up and refer to that value.