Lets say I have 5 teams (I really have many more). Each team picks one of 5
players. So column A lists the team, B lists the players, and C will at a
later time list how many points the player that they choose scored. They can
pick from 4 players, which are listed at the bottom of the sheet, and the
cell next to them will be where I can enter the points the player scores.
How can I make it so when I enter the points at the bottom, it will fill in
the correct points according to who each player picked. Here is an example
sheet:

Team: Player Points
1 A
2 B
3 C
4 D
5 A

Player Points
A 10
B 20
C 30
D 40

What do I need to enter into the B Column, so that if I enter A, it puts a
10 in C, and B puts 20 in C, etc, etc. Thanks for your help.