Correspond values of one row to another

[wood929]

I'm keeping track of points scored for players in a fantasy basketball
league. I have all of the players divided into their fantasy teams (so
that players from different schools are on the same teams). However,
I'd like to have a section at the bottom of the spreadsheet with
players grouped into the schools that they actually play for so that I
can just look at the box scores and input the points by team that way,
instead of having to go through all the fantasy teams and find each
player one by one from the team of the of the box score and entering
their points individually (very time consuming). I'd like the values
that I enter for the players grouped by school at the bottom to be
inputed to their corresponding row where each player is for their
fantasy team. This would save me so much time. Does anybody
understand what I'm trying to do or know how I could go about doing
this? Any suggestions or advice would be greatly appreciated.

 

[Tom Ogilvy]

List your players in a single column on another sheet (assume Sheet2)
organized by school. In the adjacent columns, enter your numeric values.

in your original table pull up the values by using the formula

=vlookup(B9,Sheet2!A:Z,2,False)



Where B9 is the cell on the original table containing a player name.

You would change the 2 (in this case, refering to column B) to reflect the
column that contains the number to retrieve.


See help on Vlookup for details.