+ Reply to Thread
Results 1 to 2 of 2

Constructing new table based on elements of a pre-existing table

  1. #1
    Registered User
    Join Date
    10-05-2017
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    2

    Constructing new table based on elements of a pre-existing table

    Hi,

    I have a failry urgent problem to solve. I am having trouble working out how to construct a new table based on the elements of an existing table. I'm pretty sure it's a combination of VLOOKUP and MATCH but it could also use INDEX. The existing master table and 'new' tables to be generated are below.

    Assume here that all tables are on separate worksheets and start at column A, row 1. (so headings are row 1 and data is row 2). Alternatively the new tables can go below the master table.

    I wish to construct three new tables for Engine 1, Engine 2 and Engine 3 based on the indicator 'x' in the master table. These new tables are shown below the master table. Any clue on how to help? I am not sure if a VB script is useful here or just some well placed formulas would work. I am failing with using VLOOKUP and MATCH. Any help appreciated:
    Attached Images Attached Images
    Last edited by the number cruncher; 10-05-2017 at 06:58 AM.

  2. #2
    Registered User
    Join Date
    10-05-2017
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: Constructing new table based on elements of a pre-existing table

    Sorry there, somehow editing a thread does not allow you to delete the original image. Use the bottom image.

+ 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. Constructing an Excel Table from Text File Using VBA Code
    By Lucksonc in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 09-21-2017, 03:21 PM
  2. Copying Excel table range to an existing PPT slide, pasting as TABLE, not as PICTURE
    By gurnblanston27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2016, 04:44 PM
  3. constructing a table which will update itself when new records are added
    By chrisf78 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-18-2015, 10:12 AM
  4. [SOLVED] Dynamic drop down list based on table elements - possible???
    By toblju in forum Excel General
    Replies: 2
    Last Post: 09-14-2013, 07:05 AM
  5. [SOLVED] Trying to add more rows to a table based on existing data
    By davidhale87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2013, 04:03 PM
  6. constructing table of VB codes in word...... or printing properly in excel!
    By Jet Black in forum Word Formatting & General
    Replies: 4
    Last Post: 02-12-2013, 06:25 AM
  7. Excel Freezing when Constructing Pivot Table
    By chave982 in forum Excel General
    Replies: 0
    Last Post: 01-13-2009, 09:46 AM

Tags for this Thread

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