Spreadsheet: 525226d1498616692-help-me-dominate-my-fantasy-football-draft-ff-2017-rankings_28jun17
Sheet: Sheet1

Overall Score | Name | Position | Rank 1 | Points | Rank 2 | Points | Rank 3 | Points | Average Rank | Total Points |  | Rank | Points
 | Sample Player | RB | 1 |  | 2 |  | 1 |  |  |  |  | 1 | 100
 |  |  | 3 |  | 5 |  | 15 |  |  |  |  | 2 | 99
 |  |  | 16 |  | 7 |  | 3 |  |  |  |  | 3 | 98
 |  |  | 5 |  | 4 |  | 2 |  |  |  |  | 4 | 97
 |  |  | 8 |  | 9 |  | 10 |  |  |  |  | 5 | 96
 |  |  |  |  |  |  |  |  |  |  |  | 6 | 95
 |  |  |  |  |  |  |  |  |  |  |  | 7 | 94
 |  |  |  |  |  |  |  |  |  |  |  | 8 | 93
 |  |  |  |  |  |  |  |  |  |  |  | 9 | 92
 |  |  |  |  |  |  |  |  |  |  |  | 10 | 91
 |  |  |  |  |  |  |  |  |  |  |  | 11 | 90
I've attached a basic excel spreadsheet that i want to use to prepare for my fantasy football draft. What I'm trying to do is when I enter a number in one of the "rank" columns for the value column to spit out the proper value for that rank. Ie: rank 1 equals 100 points, rank 2 equals 99 points and so on and so forth. |  |  |  |  |  |  |  |  |  |  |  | 12 | 89
 |  |  |  |  |  |  |  |  |  |  |  | 13 | 88
 |  |  |  |  |  |  |  |  |  |  |  | 14 | 87
 |  |  |  |  |  |  |  |  |  |  |  | 15 | 86
 |  |  |  |  |  |  |  |  |  |  |  | 16 | 85
 |  |  |  |  |  |  |  |  |  |  |  | 17 | 84
 |  |  |  |  |  |  |  |  |  |  |  | 18 | 83
 |  |  |  |  |  |  |  |  |  |  |  | 19 | 82
 |  |  |  |  |  |  |  |  |  |  |  | 20 | 81
 |  |  |  |  |  |  |  |  |  |  |  | 21 | 80
 |  |  |  |  |  |  |  |  |  |  |  | 22 | 79
 |  |  |  |  |  |  |  |  |  |  |  | 23 | 78
 |  |  |  |  |  |  |  |  |  |  |  | 24 | 77
 |  |  |  |  |  |  |  |  |  |  |  | 25 | 76
 |  |  |  |  |  |  |  |  |  |  |  | 26 | 75
 |  |  |  |  |  |  |  |  |  |  |  | 27 | 74
 |  |  |  |  |  |  |  |  |  |  |  | 28 | 73
 |  |  |  |  |  |  |  |  |  |  |  | 29 | 72
 |  |  |  |  |  |  |  |  |  |  |  | 30 | 71
 |  |  |  |  |  |  |  |  |  |  |  | 31 | 70
 |  |  |  |  |  |  |  |  |  |  |  | 32 | 69
 |  |  |  |  |  |  |  |  |  |  |  | 33 | 68
 |  |  |  |  |  |  |  |  |  |  |  | 34 | 67
 |  |  |  |  |  |  |  |  |  |  |  | 35 | 66
 |  |  |  |  |  |  |  |  |  |  |  | 36 | 65
 |  |  |  |  |  |  |  |  |  |  |  | 37 | 64
 |  |  |  |  |  |  |  |  |  |  |  | 38 | 63
 |  |  |  |  |  |  |  |  |  |  |  | 39 | 62
 |  |  |  |  |  |  |  |  |  |  |  | 40 | 61
 |  |  |  |  |  |  |  |  |  |  |  | 41 | 60
 |  |  |  |  |  |  |  |  |  |  |  | 42 | 59
 |  |  |  |  |  |  |  |  |  |  |  | 43 | 58
 |  |  |  |  |  |  |  |  |  |  |  | 44 | 57
 |  |  |  |  |  |  |  |  |  |  |  | 45 | 56
 |  |  |  |  |  |  |  |  |  |  |  | 46 | 55
 |  |  |  |  |  |  |  |  |  |  |  | 47 | 54
 |  |  |  |  |  |  |  |  |  |  |  | 48 | 53
 |  |  |  |  |  |  |  |  |  |  |  | 49 | 52
 |  |  |  |  |  |  |  |  |  |  |  | 50 | 51
 |  |  |  |  |  |  |  |  |  |  |  | 51 | 50
 |  |  |  |  |  |  |  |  |  |  |  | 52 | 49
 |  |  |  |  |  |  |  |  |  |  |  | 53 | 48
 |  |  |  |  |  |  |  |  |  |  |  | 54 | 47
 |  |  |  |  |  |  |  |  |  |  |  | 55 | 46
 |  |  |  |  |  |  |  |  |  |  |  | 56 | 45
 |  |  |  |  |  |  |  |  |  |  |  | 57 | 44
 |  |  |  |  |  |  |  |  |  |  |  | 58 | 43
 |  |  |  |  |  |  |  |  |  |  |  | 59 | 42
 |  |  |  |  |  |  |  |  |  |  |  | 60 | 41
 |  |  |  |  |  |  |  |  |  |  |  | 61 | 40
 |  |  |  |  |  |  |  |  |  |  |  | 62 | 39
 |  |  |  |  |  |  |  |  |  |  |  | 63 | 38
 |  |  |  |  |  |  |  |  |  |  |  | 64 | 37
 |  |  |  |  |  |  |  |  |  |  |  | 65 | 36
 |  |  |  |  |  |  |  |  |  |  |  | 66 | 35
 |  |  |  |  |  |  |  |  |  |  |  | 67 | 34
 |  |  |  |  |  |  |  |  |  |  |  | 68 | 33
 |  |  |  |  |  |  |  |  |  |  |  | 69 | 32
 |  |  |  |  |  |  |  |  |  |  |  | 70 | 31
 |  |  |  |  |  |  |  |  |  |  |  | 71 | 30
 |  |  |  |  |  |  |  |  |  |  |  | 72 | 29
 |  |  |  |  |  |  |  |  |  |  |  | 73 | 28
 |  |  |  |  |  |  |  |  |  |  |  | 74 | 27
 |  |  |  |  |  |  |  |  |  |  |  | 75 | 26
 |  |  |  |  |  |  |  |  |  |  |  | 76 | 25
 |  |  |  |  |  |  |  |  |  |  |  | 77 | 24
 |  |  |  |  |  |  |  |  |  |  |  | 78 | 23
 |  |  |  |  |  |  |  |  |  |  |  | 79 | 22
 |  |  |  |  |  |  |  |  |  |  |  | 80 | 21
 |  |  |  |  |  |  |  |  |  |  |  | 81 | 20
 |  |  |  |  |  |  |  |  |  |  |  | 82 | 19
 |  |  |  |  |  |  |  |  |  |  |  | 83 | 18
 |  |  |  |  |  |  |  |  |  |  |  | 84 | 17
 |  |  |  |  |  |  |  |  |  |  |  | 85 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 86 | 15
 |  |  |  |  |  |  |  |  |  |  |  | 87 | 14
 |  |  |  |  |  |  |  |  |  |  |  | 88 | 13
 |  |  |  |  |  |  |  |  |  |  |  | 89 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 90 | 11
 |  |  |  |  |  |  |  |  |  |  |  | 91 | 10
 |  |  |  |  |  |  |  |  |  |  |  | 92 | 9
 |  |  |  |  |  |  |  |  |  |  |  | 93 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 94 | 7
 |  |  |  |  |  |  |  |  |  |  |  | 95 | 6
 |  |  |  |  |  |  |  |  |  |  |  | 96 | 5
 |  |  |  |  |  |  |  |  |  |  |  | 97 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 98 | 3
 |  |  |  |  |  |  |  |  |  |  |  | 99 | 2
 |  |  |  |  |  |  |  |  |  |  |  | 100 | 1