Try this:

Assume you have this table in the range G2:H5

A 10
B 20
C 30
D 40

This stuff is in the range A2:B6

1 A
2 B
3 C
4 D
5 A

Enter this formula in C2 and copy down to C6:

=IF(B2="","",VLOOKUP(B2,G$2:H$5,2,0))

Biff

"Sarah" wrote in message
...
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.