+ Reply to Thread
Results 1 to 3 of 3

If A and B Match in one row on sheet 2 print C from same row in F on Sheet 1

  1. #1
    Registered User
    Join Date
    08-28-2014
    Location
    Toronto, Canada
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Question If A and B Match in one row on sheet 2 print C from same row in F on Sheet 1

    Not sure if this is the right forum for this question but seems like it would be pretty basic.

    If A and B Match in one row on sheet 2 print C from same row in F on Sheet 1

    I have a Rosters sheet and a score sheet. I need the games played by a player on a specific team on the score sheet. I started drawing the overall games played on another sheet but that wrong. I used this to draw the wrong data
    Please Login or Register  to view this content.
    The player sheet is the players league wide total so no good for this and the formula doesn't help without the if matches stuff.

    In F15
    If C13 (Scoresheet) matches B (Rosters) and C15 (Scoresheet) matches E (Rosters) of the same row print F (Rosters)

    Trying to wrap my head around it but could use some help if possible.

  2. #2
    Registered User
    Join Date
    08-28-2014
    Location
    Toronto, Canada
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Re: If A and B Match in one row on sheet 2 print C from same row in F on Sheet 1

    This one of the Scoresheet sheet tables

    Team ID
    33017 The Pirates
    Player ID GP HC
    10101 5 3 Webster, Max
    10202 4 4 Bundy, Bud
    10303 12 7 Crosby, Sidney
    10404 9 4 Woods, Tiger
    Team ID Team Name Player ID Games Played Handicap Player name
    33000 Team A 10101 ? 3 Webster, Max
    33000 Team A 10202 ? 4 Bundy, Bud
    44000 Team B 10101 ? 3 Webster, Max
    55000 Team C 10202 ? 4 Bundy, Bud


    This is Part of the Rosters Sheet
    Team Name Team ID Player Rank Player Name Player ID Games Played

    Team Name Team ID Handicap Player Player ID Games
    Pooloholics 33000 3 Webster, Max 10101 5
    Pooloholics 33000 4 Bundy, Bud 10202 4
    Team B 44000 3 Webster, Max 10101 5
    Team C 55000 4 Bundy, Bud 10202 4

  3. #3
    Registered User
    Join Date
    08-28-2014
    Location
    Toronto, Canada
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Re: If A and B Match in one row on sheet 2 print C from same row in F on Sheet 1

    Sorry.. Edit post doesn't seem to work here so let me just say "Pooloholics" should be "Team A"

    And... This part of the Scoresheet is the actual format printed on the sheet.. The Score sheet table is just to make my question clearer.
    Team ID
    33017 The Pirates
    Player ID GP HC Player Name
    10101 5 3 Webster, Max
    10202 4 4 Bundy, Bud
    10303 12 7 Crosby, Sidney
    10404 9 4 Woods, Tiger

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match Value in Sheet 1 with Sheet 2, copy entire row from sheet 1 to new sheet
    By lzyshaman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2013, 07:48 AM
  2. look up on sheet 1 match data sheet 2 and fill in cell on first sheet
    By treborharris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-28-2013, 01:01 PM
  3. [SOLVED] Lookup up from Sheet 1 in Sheet 2 and display additional value in Sheet 1 when match
    By azbridgie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2013, 03:22 PM
  4. Replies: 11
    Last Post: 10-14-2012, 01:03 PM
  5. Match column from sheet 2 to sheet 1 and copy rows if match exists.
    By GravityInvert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2008, 01:42 PM

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