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

S

Sarah

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

Sarah

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
 
S

Sarah

Perfect, Thank you so much for your help.

T. Valko said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top