+ Reply to Thread
Results 1 to 3 of 3

Creating "product selector" using multi level data validation that generates pricing quote

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2010
    Posts
    27

    Question Creating "product selector" using multi level data validation that generates pricing quote

    My boss has asked me to use Excel to create a "product selector" that will be used to aid the web developers when they create the real thing for the company's new website. There are 6 different categories of products, with multiple products in each category. In three of those categories, you can only choose one product, where in the other three you can select multiple products. I have created a multi-level data validation chart, where there are drop down menus next to each category for you to select all the products you are looking for. Now, I need to find a way where this chart will spit out the cost of each product selected into a pricing quote so the customer can see how much their order will cost. Even further, they can purchase their products two different ways... basically just the product or the product with full-service support. So I would like for the chart to spit out a quote for BOTH options so the customer can see a side by side comparison.

    Can I get a multi-level data validation chart to spit out two costs onto another worksheet with the 2 quotes, depending on what is selected? Is this even possible?

    If not... how could I do this? Multi-level vlookup? Filtering?

    Thanks.

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Creating "product selector" using multi level data validation that generates pricing q

    I would suggest posting a sample workbook, showing what you have, and an example of what you want to have returned.
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    02-07-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Creating "product selector" using multi level data validation that generates pricing q

    I apologize for the late response... I was able to use a friend who is an Excel wizard to help in person, and we got this figured out! Thanks for attempting to help!

+ 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