+ Reply to Thread
Results 1 to 2 of 2

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'm looking to pull data from one sheet to another as well as the criteria on the second sheet factoring in.

    For example, in my workbook I have two sheets, In Sheet 2, I want cells H3:H6 to formulate based on the info in Cells C2:C4 of Sheet 1 (which will always be changing based on number entered) and the results of cells C3:G6 of Sheet 2.

    On Sheet 1, Hitting consists of cells C3:E6 on Sheet 2, Starting Pitching cells F3:F6 on Sheet 2 and Relief Pitching cells G3:G6 Sheet 2. I want cells H3:H6 to be listed in order of cells C2:G2 and listed in a drop down menu as well.

    What the worksheet should look like when finished is in Sheet 3.

    Thanks and please let me know if there are any questions!
    Attached Files Attached Files
    Last edited by mlbdc2012; 02-05-2015 at 01:52 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    604

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

    Hi, pretty sure I know what you need, but I don't understand how the numbers work.
    Can you tell me the formula or rules that give you the answers 20,5,8 in Sheet 1 please?
    And then what rules say that Mike is eligible for either 1B or 2B (is that because his 1B and 2B scores are above the 20?)

+ 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] 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
  2. [SOLVED] Pulling a row from a range to another sheet based on criteria
    By hornet7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2012, 07:58 AM
  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