+ Reply to Thread
Results 1 to 4 of 4

Trying to create a list from a table.

  1. #1
    Registered User
    Join Date
    03-09-2019
    Location
    Alberta, Canada
    MS-Off Ver
    2013
    Posts
    2

    Trying to create a list from a table.

    I need to create a list from a table of data. I have used the match function on my data input worksheet to reference a row in my table worksheet, but I'm struggling on populating a list from the table. I have very little experience with Excel, and I'm not sure how to phrase my commands. I hope someone out there can make sense of this.

    Regards,

    Mile299

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Trying to create a list from a table.

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    03-09-2019
    Location
    Alberta, Canada
    MS-Off Ver
    2013
    Posts
    2

    Re: Trying to create a list from a table.

    Sorry, I should have guessed that. Please find the file attached. The list1! table is what I am trying to use to populate a drop-down list in the data input page.
    I want to be able to use excel to manage different pipe wall thicknesses for the work that I'm doing, This about version four of this project, and I think maybe
    it is better to just ask for advice.

    Thank you for your time,

    Mile299
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Trying to create a list from a table.

    Named ranges:
    Please Login or Register  to view this content.
    Data val for pipe sizes: =SizeList
    dv for schedules: =schedules
    lookup O.D.: =VLOOKUP(D3,Table1[[#All],[Size]:[O.D.]],2,FALSE)
    wall thickness intersects size and sched: =INDEX(Table1,MATCH(NPS,SizeList,0),MATCH(Sched,schedules,0)+2)
    Attached Files Attached Files
    Ben Van Johnson

+ 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] Create List with two columns from table.
    By Stenn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2018, 06:38 AM
  2. [SOLVED] Create List From Table
    By trench3368 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-04-2018, 12:05 PM
  3. Create a list from Table
    By sqrcbc in forum Excel General
    Replies: 1
    Last Post: 09-12-2017, 08:19 PM
  4. Index on Table to Create a list
    By dmills21 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2016, 08:47 PM
  5. [SOLVED] Create list from table
    By Networkdrone in forum Excel General
    Replies: 4
    Last Post: 01-02-2016, 07:21 AM
  6. Create a list from a table
    By Jogier505 in forum Excel General
    Replies: 4
    Last Post: 09-13-2010, 02:17 PM
  7. Create List from Pivot Table
    By JoeyGirl in forum Excel General
    Replies: 7
    Last Post: 02-26-2010, 01:21 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