+ Reply to Thread
Results 1 to 5 of 5

How to Identify Value from Table in One Sheet and Return Corresponding (Multiple) Rows

  1. #1
    Registered User
    Join Date
    06-22-2013
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2011 (Mac)
    Posts
    2

    How to Identify Value from Table in One Sheet and Return Corresponding (Multiple) Rows

    Hi guys/girls,

    I am new to this and am looking to see if anyone can solve my problem. I few tables worth of data in one sheet. I want to pull data to another sheet based on a given value/indicator. I have tried using Index & Match functions together but had some problems as the indicator comes up more than once in some tables. I want to consolidate data for each team separately in another sheet - for example, I want to show the projected stats for everyone on New Orleans (NO in column A). Can anyone help me with this?

    Thanks a bunch!

    -Joe


    Fantasy Football 2013b.xlsx

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to Identify Value from Table in One Sheet and Return Corresponding (Multiple) Row

    Hoping this will help
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to Identify Value from Table in One Sheet and Return Corresponding (Multiple) Row

    sorry for the last piece, this is better
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to Identify Value from Table in One Sheet and Return Corresponding (Multiple) Row

    an improvement
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-22-2013
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2011 (Mac)
    Posts
    2

    Re: How to Identify Value from Table in One Sheet and Return Corresponding (Multiple) Row

    Awesome!! This is exactly what I was looking for - I am not all that familiar with running macros in Excel, though. How can I see the code that you wrote? And should I be able to just change the team and click "Button 2" to see the new team projections?

    Thanks again!
    Joe

+ 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