Help with IF (at least I think I need to use IF)
 

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.

Help with IF (at least I think I need to use IF)
 

=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.

Help with IF (at least I think I need to use IF)
 

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.

Help with IF (at least I think I need to use IF)
 

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.

Help with IF (at least I think I need to use IF)
 

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.

Help with IF (at least I think I need to use IF)
 

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.