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.

=CHOOSE(UPPER(CODE(B1))-64,10,20,30,40)


"Sarah" wrote:

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.

So what do I do if the players are not letters, but are numbers. Say
A=48,B=17, C=9, and D=29. Still score the same amount of points, just
instead of letters I use numbers, the what does my formula look like? Thanks

"Teethless mama" wrote:

=CHOOSE(UPPER(CODE(B1))-64,10,20,30,40)


"Sarah" wrote:

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.

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.

Perfect, Thank you so much for your help.

"T. Valko" wrote:

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.

You're welcome. Thanks for the feedback!

Biff

"Sarah" wrote in message
...
Perfect, Thank you so much for your help.

"T. Valko" wrote:

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.