+ Reply to Thread
Results 1 to 8 of 8

Pulling Data from a sheet based on criteria on both those sheets

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Pulling Data from a sheet based on criteria on both those sheets

    In my attached workbook I have two names on each of the two sheets. On the Stats Sheet I have the two names with a list of statistics. I want these statistics to pull to the Board Sheet based on criteria entered in Column H of the Board Sheet.

    I've included minor further instructions in my worksheet. It's probably a really quick fix just not exactly sure how to get there. Thanks for any help!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Pulling Data from a sheet based on criteria on both those sheets

    Your "Board" sheet has data filled in already. Where do you want the formulas?

  3. #3
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Re: Pulling Data from a sheet based on criteria on both those sheets

    Quote Originally Posted by NS4Excel View Post
    Your "Board" sheet has data filled in already. Where do you want the formulas?
    It does but do you see how for the second player it doesn't replicate the values of that same player on the Stats page because they are located in columns N thru X not C thru M like the first player listed. I have the same formulas entered for both players because they need to show up in the same columns that's why I need it to specify if it should look up columns C thru M or N thru X based on the criteria for each player in Column H.

  4. #4
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Pulling Data from a sheet based on criteria on both those sheets

    So, in the Board sheet in cell I3, you want whatever's in the Stats sheet cells n3-X4 if:
    Board H3 does not equal SP, RP or P
    Stats column B = Board D3
    Stats Row 2 = what?
    Is this correct? If so, tell me what the Stats Row 2 need to equal on the Board sheet.

  5. #5
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Re: Pulling Data from a sheet based on criteria on both those sheets

    Cell i3 is formatted correctly, cell i4 needs to reference columns n:x of the stats board because it has an SP in cell H4. Does that make sense? Thanks

  6. #6
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Pulling Data from a sheet based on criteria on both those sheets

    Stats.xlsxSee if the attached file works for you based on the cells highlighted in green.

    **If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of the posts.

  7. #7
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Re: Pulling Data from a sheet based on criteria on both those sheets

    Quote Originally Posted by NS4Excel View Post
    Attachment 375451See if the attached file works for you based on the cells highlighted in green.

    **If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of the posts.
    Yes the right values are pulling but the formatting is wrong. In your Green Cells, cells R21 and S21 should only have two decimals, and all the other cells with three decimals should be whole numbers. Cells L20:O20 are formatted correctly as well. Thanks!

  8. #8
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Pulling Data from a sheet based on criteria on both those sheets

    I'm confused. First off there is no R21 and S21 in the file I sent you. The green highlighted cells are in rows 17 and 18. Also, I used your instructions highlighted in blue on the Board sheet. Those instructions read:
    IF Cell H3:H4 equals anything other than SP,RP or P please make columns L:O of the Board Sheet use the format with the .000
    IF Cell H3:H4 equals SP,RP or P than match columns R:S of the Board Sheet use the format with 0.00

    Row 17 has OF in column H so the cells are formatted to .000 and row 18 has SP in column H so the cells are formatted to 0.00.

+ 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. Pulling Data from a sheet based on criteria on both those sheets
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2015, 10:39 AM
  2. [SOLVED] Pulling Data from two separate sheets based on criteria on both those sheets
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2015, 03:57 PM
  3. Replies: 1
    Last Post: 08-08-2011, 06:00 PM
  4. Replies: 1
    Last Post: 07-14-2010, 07:08 PM
  5. Pulling to a new sheet based on Criteria
    By mjhopler in forum Excel General
    Replies: 1
    Last Post: 09-18-2009, 09:10 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