+ Reply to Thread
Results 1 to 2 of 2

Make 2 dependent drop down lists dynamic

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    17

    Exclamation Make 2 dependent drop down lists dynamic

    Hello all,

    I have gotten a lot of support from people using this forum to help me with my spreadsheet, I am hoping someone out there knows how to fix this one.
    For a quick background, this spreadsheet looks up values (pipe sizes and description) and returns the price for each item selected.
    The way you select these items is through 2 dependent drop down lists (ex. you first choose the pipe size, then the 2nd drop down list shows the descriptions matching that pipe size - from 1st drop down, once you select the description, the price is shown).
    The issue I am now running into is what I am guessing a formula issue?
    I need to be able to add pipe sizes and descriptions to my list and the drop down lists to update accordingly.
    If you look at the attached spreadsheet, at the very bottom, I added a size 16'' with its description. Unfortunately, only the pipe size shows up on the 1st drop down list, the 2nd drop down list doesn't show the description.

    Any help would be greatly appreciated!

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Make 2 dependent drop down lists dynamic

    find attached ! referncing was an issue in the formula for incorrect results.

    Hope this Helps

    If this solves your query mark thread as solved and Add Rep by clicking "*" star icon in the bottom left corner of my post.
    Attached Files Attached Files
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

+ 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. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  2. [SOLVED] Dependent drop down lists- dynamic data range- excluding Headers
    By strud in forum Excel General
    Replies: 3
    Last Post: 05-28-2013, 04:10 AM
  3. [SOLVED] Dependent drop down lists based on dynamic data range
    By strud in forum Excel General
    Replies: 15
    Last Post: 04-19-2013, 08:08 AM
  4. [SOLVED] Trying to make multiple dependent drop down list with dynamic ranges
    By Gwen@YouWantWhat? in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-01-2012, 12:55 AM
  5. Dependent and dynamic drop-down lists
    By csunseri in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2011, 04:32 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