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

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[T. Valko]

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

 

[Guest]

Perfect, Thank you so much for your help.

Try this:

Assume you have this table in the range G2:H5


This stuff is in the range A2:B6


Enter this formula in C2 and copy down to C6:

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

Biff

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Perfect, Thank you so much for your help.