+ Reply to Thread
Results 1 to 4 of 4

Match and List Values from another Table - Help please!

  1. #1
    Registered User
    Join Date
    08-08-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    15

    Match and List Values from another Table - Help please!

    Hi there,

    I have a dynamic Table 1 as follows (with times in difference cells):

    Tram A ---- Time 1, Time 2, Time 3, Time 4, Time 5
    Tram B ---- Time 1, Time 2, Time 3, Time 4, Time 5, Time 6
    Tram C ---- Time 1, Time 2, Time 3, Time 4
    Tram D ---- Time 1, Time 2, Time 3
    Tram E ---- Time 1, Time 2, Time 3, Time 4

    And then another dynamic list (Table 2) here that I would like to match the Tram ID and populate the Times automatically from Table 1:

    Tram A ---- (auto populate with Table 1 times)
    Tram D ---- (auto populate with Table 1 times)
    Tram E ---- (auto populate with Table 1 times)

    The trams in Table 2 could change automatically, so would need to list the times for the same Tram ID found in Table 1. I would like to avoid VBA as much as I can please to keep it user friendly.

    Thanks for your help!
    Last edited by sgreenprice; 09-25-2017 at 07:06 AM.

  2. #2
    Registered User
    Join Date
    10-01-2012
    Location
    Noida, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Match and List Values from another Table - Help please!

    Well in such a case you can use a simple VLOOKUP function to match the TramID in table 2.
    Let's say the Table one is in a spreadsheet in cells A1:B5

    In the time column of the next table in each cell use the function: =VLOOKUP('cell address of Table 2 Tram ID',A1:B5,2,0)

    https://www.youtube.com/excelissimple

  3. #3
    Registered User
    Join Date
    08-08-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    15

    Re: Match and List Values from another Table - Help please!

    Hi akhilkakroo, thanks for your response.

    I've thought about using VLOOKUP but those Tram Times are actually in different cells, I don't think VLOOKUP would still work?

  4. #4
    Registered User
    Join Date
    08-08-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    15

    Re: Match and List Values from another Table - Help please!

    I made it work with VLOOKUP, you're right. Thanks!!!

+ 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: 5
    Last Post: 02-18-2017, 11:21 AM
  2. [SOLVED] Create drop down list with range of values that is exact match from a table
    By glenwalcuch in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-22-2015, 03:09 PM
  3. List all values that match a lookup table
    By cworkman123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-19-2015, 01:34 PM
  4. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  5. Replies: 1
    Last Post: 07-27-2011, 04:19 AM
  6. [SOLVED] Match row that contains text text string; list associated values from pivot table
    By ACurtis802 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2009, 07:50 PM
  7. Function to match random list values to set list values.
    By Sandman4432 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2007, 09:22 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