+ Reply to Thread
Results 1 to 3 of 3

Create a report table from the two original tables (source and select criteria)

  1. #1
    Registered User
    Join Date
    03-31-2014
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Create a report table from the two original tables (source and select criteria)

    Dear All: This is my first posting here. I need your advice.

    I have two tables (Table 1 and Table 2). Table 1 has names of all employees in my organization ('Name' column) and corresponding information in the second column ('Textinfo'). I need to create Table 3 from table 1, but only select those employees who are in my team, ie matching names in the Table 2. I also need to extract corresponding 'Textingo' column information. I tried vlookup but it did not work because if there more that one name in the table 1, vlookup confuses it (i think). Would you know what function or code to use? Many thanks! (sample file is attached)

    excel question 1.xlsx
    Last edited by drhope; 03-31-2014 at 01:10 PM. Reason: corrected attachment link

  2. #2
    Forum Contributor Bhuvi's Avatar
    Join Date
    04-19-2013
    Location
    Delhi, India
    MS-Off Ver
    MS Excel 2003,07,10
    Posts
    153

    Re: Create a report table from the two original tables (source and select criteria)

    Hi drhope,
    Welcome to the forum

    You can use the Advance filter option to get this result.
    goto Data >> Advanced >> check Copy to another location
    *in the list range provide your table 1 range
    *in the criteria range provide table 2 range (the table 2 header should be same as to table1 first col)
    * copy to location of your choice (mention single cell).
    If this helped and you wish to say thanks, then Please click on the Star* icon below this post.

  3. #3
    Registered User
    Join Date
    03-31-2014
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Create a report table from the two original tables (source and select criteria)

    Dear Bhuvi: This is so helfpul! Thank you for sharing your wisdom.

+ 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. Replies: 1
    Last Post: 02-23-2013, 08:22 AM
  2. Replies: 2
    Last Post: 08-15-2011, 03:31 PM
  3. Excel 2007 : Pivot tables distort original data source
    By Anudinee in forum Excel General
    Replies: 0
    Last Post: 06-15-2009, 07:58 PM
  4. Original Source of Pivot Table Data
    By akexcel in forum Excel General
    Replies: 3
    Last Post: 05-08-2007, 09:53 AM
  5. [SOLVED] Pivot Table Report formatting - can't select Data Source Order
    By Becky in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 02:05 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