+ Reply to Thread
Results 1 to 1 of 1

Pull data from hierarchy of multiple dependant lists

  1. #1
    Registered User
    Join Date
    12-05-2014
    Location
    Houston, Texas
    MS-Off Ver
    2008 Excel: Mac
    Posts
    1

    Pull data from hierarchy of multiple dependant lists

    I have created a sample inventory of metals I keep on hand in my shop. I would like to build an estimating spreadsheet that includes drop-down dependent lists (like I've already started). The ultimate goal is to extract the price of each item after I've selected the corresponding drop-downs.

    For example:
    1- I carry a line of either steel or aluminum (list #1)
    2- I carry a line of steel angle, steel flat bar, steel round bar, etc. as well alum. angle, alum. flat bar, alum.round bar, etc. (lists #2 & #3)
    3- I carry a line of different sized steel angles, different sized steel flat bars, etc. and different sized alum. angles, different sized alum. flat bars, etc. (Lists #4 & #5)

    My drop-down lists work just like I'd like them to but I'm having trouble coming up with the formula to extract the price using the parameters I've selected. I'm thinking some form of VLOOKUP or MATCH but I may be barking up the wrong side of the tree.
    I'm also not married to the list setup, so if there is a more efficient way to handle this, I'm open to suggestions.

    Thank you kindly!
    ---Ford
    Attached Files Attached Files

+ 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] Auto Clear Multiple Dependant Dropdown Lists
    By Nexial in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2014, 11:15 AM
  2. Data Validation. Multiple Dependant Lists Required
    By David_Schop in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2013, 07:35 AM
  3. [SOLVED] Dependant lists (multiple)
    By G.Bregvadze in forum Excel General
    Replies: 7
    Last Post: 06-22-2013, 01:12 PM
  4. Please help with multiple dependant drop down lists
    By kartoshka in forum Excel General
    Replies: 6
    Last Post: 05-12-2013, 07:59 AM
  5. Multiple Dependant Drop Down Lists
    By shoo0204 in forum Excel General
    Replies: 19
    Last Post: 03-08-2013, 04:49 PM

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