+ Reply to Thread
Results 1 to 2 of 2

Correspond values of one row to another

  1. #1
    Registered User
    Join Date
    12-04-2005
    Posts
    1

    Correspond values of one row to another

    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.

  2. #2
    Tom Ogilvy
    Guest

    Re: Correspond values of one row to another

    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.
    --
    Regards,
    Tom Ogilvy

    "wood929" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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.
    >
    >
    > --
    > wood929
    > ------------------------------------------------------------------------
    > wood929's Profile:

    http://www.excelforum.com/member.php...o&userid=29353
    > View this thread: http://www.excelforum.com/showthread...hreadid=490601
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1