Results 1 to 3 of 3

Need to return a value that might be in the row above or the row below...help?

Threaded View

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    Oakland, CA
    MS-Off Ver
    Excel 2003
    Posts
    8

    Need to return a value that might be in the row above or the row below...help?

    I play fantasy football, and keep a spreadsheet of scores and such for bonuses, finances, etc.

    Each week I manually enter the scores of each matchup, but looking to just copy/paste the table from the website, which calculate for us.

    See the attached example. We are currently on week 6 or our season, so I am using week 6 as an example.

    The second sheet (Week 6 result) is how the table pastes. It shows the team name in column A, the score in column B. The head-to-head matchups are indicated in every other row in column C.

    On the 1st sheet (Scores) you'll see I've used a VLOOKUP formula to return the score for each team in their Pts For column. (As long as people don't go changing their team name!)

    But, I'm stuck figuring out how to return the Pts Against value for each team (what their opponent scored.) The row numbers will differ week to week for each team, depending on the matchups.

    But basically, what I want is is to find my score, and if it's in an ODD row (which also contains the "Match Up" text in column C, then return the score below mine. If it's in an even row (without the "Match Up" text), then return the score above mine.

    Any suggestions on how to do this? I feel like a combination of Index(), Match(), If() should all work, but I can't seem to get it right.

    Thanks,
    Ben
    Attached Files Attached Files

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