Results 1 to 2 of 2

Thread: Need assitance with a complicated lookup tool.

  1. #1

    Need assitance with a complicated lookup tool.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I'm trying to create a simple lookup tool, which displays cable and equipment data relevant to a selection from a drop down menu. I have attached an example workbook.

    There are three worksheets. The first, LOOKUP, has the dropdown menu, sourcing it's data for the list from the second worksheet, T_CODES. On the first worksheet I want one column that will display all of the cables relevant to the selction in the drop down menu. The third sheet, RAW_DATA, has the cable information listed under their respective systems (named by their Turnover Codes); notice how the different systems share some of the same cables.

    My biggest difficulty is getting the Column "Cable Number" on the first sheet to dynamically populate the cables (down the sheet, in individual cells) depending on what Turnover Code is selected from the drop down list. Is this even possible?

    The live workbook that will be used will contain a lot of data, hence why I'm trying to make an easy tool for people to use. They can simply select the Turnover Code for the system they are working on, and it will display all the cables that concern their system.

    Any ideas on how I can do this, or am I coming at this from the wrong direction?

    Cheers!

    Example.xlsx

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    778
    Articles
    0
    Excel Version
    2010
    Hello
    Have a look at this earlier thread, which might be of help.


    http://www.excelguru.ca/forums/showt...ddress-databas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •