+ Reply to Thread
Results 1 to 2 of 2

Retrieving data table with 3 columns

  1. #1
    Registered User
    Join Date
    08-07-2017
    Location
    Birmingham
    MS-Off Ver
    365 Pro Plus
    Posts
    3

    Retrieving data table with 3 columns

    Issue:




    Looking for a formula that will allow me to pull data from table on another sheet by name.


    See attached table.


    I want to pull the data for Joe Johnson. I need to match the name (Col A) and pull the data from each Area (Col B) and the Duration time (Col C) associated with each Area.


    Hopefully that explanation is clear enough
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Retrieving data table with 3 columns

    What's in row 9; another name, a blank row? A spreadsheet will get you more responses than an image (Go Advanced>Manage Attachments)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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] Retrieving list of data from a table
    By arjhen in forum Excel General
    Replies: 15
    Last Post: 01-05-2014, 03:46 AM
  2. Retrieving cells from different columns to a new table
    By maherbeik in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-29-2013, 02:14 PM
  3. Excel 2007 : Retrieving data from multiple table into one table
    By nazruleffendy in forum Excel General
    Replies: 1
    Last Post: 04-20-2010, 12:41 AM
  4. Retrieving Data from a Table
    By cbudrecki in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2009, 02:33 AM
  5. Retrieving data from table
    By dooners99 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-23-2008, 11:30 PM
  6. Retrieving DATA from a table???
    By RMThompson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2007, 09:10 AM
  7. [SOLVED] Retrieving Data from Pivot Table
    By Jasper in forum Excel General
    Replies: 3
    Last Post: 03-03-2005, 10:06 AM

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