Results 1 to 7 of 7

Return multiple values (matrice) by selection of multiple criteria.

Threaded View

toman159 Return multiple values... 11-28-2016, 09:43 AM
Olly Re: Return multiple values... 11-28-2016, 09:49 AM
toman159 Re: Return multiple values... 11-28-2016, 10:08 AM
Olly Re: Return multiple values... 11-28-2016, 10:29 AM
toman159 Re: Return multiple values... 11-28-2016, 10:51 AM
toman159 Re: Return multiple values... 11-28-2016, 10:58 AM
Olly Re: Return multiple values... 11-28-2016, 11:05 AM
  1. #1
    Registered User
    Join Date
    04-14-2015
    Location
    Sweden
    MS-Off Ver
    2010
    Posts
    4

    Return multiple values (matrice) by selection of multiple criteria.

    Hi there,

    Hopefully someone can help me with my problem. I want to with the help of selections (n number of drop down lists) define a criteria (i.e. find a special row) and return a set of values in that row. The drop down list part i know how, its just for explanatory reasons. As shown by example: (I apologize for the spacing, didnt know how).

    ListA Model 1
    ListB Config 3
    ListC ONE

    A B C 0% 20% 40% 60% 80% 100%
    Model 1 Config 1 ONE 1 2 4 8 16 32
    Model 1 Config 2 ONE 1 3 6 12 24 48
    Model 1 Config 3 ONE 1 2 6 18 52 156
    Model 2 Config 1 TWO 0 1 2 3 4 5
    Model 2 Config 2 ONE 0 5 10 15 20 25
    Model 2 Config 3 ONE 0 3 6 9 12 15


    Desired return value: 1 2 6 18 52 156

    or 1
    2
    6
    18
    52
    156
    which ever


    Excel version: MS Office Pro Plus 2010

    Hope someone can provide me with a solution.

    BR
    Last edited by toman159; 11-28-2016 at 09:48 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index/Match with Multiple Criteria and Multiple return values
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2015, 10:27 AM
  2. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  3. [SOLVED] How to return multiple values to a single cell based on multiple criteria
    By lwallace in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2014, 06:32 AM
  4. Replies: 2
    Last Post: 03-03-2014, 10:03 PM
  5. [SOLVED] Return Multiple Values with Multiple Criteria
    By JonnyMa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2013, 03:50 PM
  6. Select multiple criteria based on check box selection and return all unique values.
    By TommyToe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 09:14 AM
  7. Replies: 6
    Last Post: 07-26-2011, 04:36 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