+ Reply to Thread
Results 1 to 2 of 2

Drop down with conditional results / nesting alternative

  1. #1
    Registered User
    Join Date
    04-02-2015
    Location
    London
    MS-Off Ver
    Ecel 2013
    Posts
    13

    Drop down with conditional results / nesting alternative

    Hi,

    I have been working on an excel table with multiple drop down menus.

    Example:

    Country Product Industry Sales
    a 1
    b 2
    c 3
    d 4

    The table above shows an example of my 3 categories and depending on what is chosen for country, product and industry, the output for sales will vary. So users can choose a country, product and industry and then choose between high sales, medium, sales or low sales. These are all drop down menus.

    E.g. If I choose Country a, product b and industry c with medium sales, I will get 0.2 as a result.
    If I choose country a, product b and industry c with high sales, I will get 0.4 as a result.

    I have all individual results in a big table but would like to have them as individual drop downs, kind of like using a converter, so depending on what categories you choose your output will vary.

    Country, Product and industry are all independent from each other, but sales output varies with the change of each individual drop down.

    I figured out this formula:
    =INDEX($J$1:$J$5,MATCH(1,(($F$1:$F$5="UK")*($G$1:$G$5="Xbox 360")*($H$1:$H$5="Automotive")*($I$1:$I$5="High")),0))

    This gives me the output for a set combination of criteria, but I would have to use an endless if function to add all individual possibilities in combinations.

    Any ideas?

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Drop down with conditional results / nesting alternative

    This may help:
    http://www.contextures.com/xlDataVal02.html
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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] An alternative to Nesting IF
    By Aland2929 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2014, 04:13 AM
  2. VLookup alternative showing multiple results
    By mfahmie66 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-20-2012, 05:35 PM
  3. Alternative to nesting formula? "IF(ISNUMBER(SEARCH"
    By ad9051 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-19-2012, 06:12 AM
  4. Replies: 2
    Last Post: 10-13-2011, 04:41 PM
  5. Alternative Results in a v/hlookup
    By ani4ani in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-25-2007, 10:14 AM

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