+ Reply to Thread
Results 1 to 2 of 2

Drop Down List, numeric output dependent on selection

  1. #1
    Registered User
    Join Date
    02-12-2011
    Location
    Cork
    MS-Off Ver
    Excel 2010
    Posts
    21

    Drop Down List, numeric output dependent on selection

    Hello,

    Please find attached a PDF to help explain/visualize what i am trying to achieve. The following example will make much more sense if you have the PDF open.

    Looking at 'Define your Equipment type' we have three inputs. This can be seen on the attached excel file. For example if you pick 'Vessel' followed by 'Liquid' and finally 'Group 2' the output i'm trying to achieve is Table 4. Alternatively if you pick steam generator, table 5 will be output to the screen as no further inputs are required.

    I hope that makes sense. I have attempted to complete this exercise by assigning a numeric value to each of the options and then depending on the value returned assign the correct table which works OK but is not the cleanest of methods especially if the table is to be expanded at a later time.

    Many Thanks in advance!!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Drop Down List, numeric output dependent on selection

    I added a little table with the possible combinations.
    Then used the Sumproduct formula to do a lookup with 3 criteria.
    Attached Files Attached Files
    Kind regards,
    Piet Bom

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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