+ Reply to Thread
Results 1 to 5 of 5

Help with list of values

  1. #1
    Registered User
    Join Date
    09-23-2006
    Posts
    3

    Help with list of values

    Hi,

    I would appreciate your advice; I have a spreadsheet in Excel, which Iím trying to make as easy as possible for users (seriously).

    I have three columns and in two of the columns I have a drop down list, how can I get the third column to come up with the answer, however columns one and two have many different combinations. The answer is also in text and not in numbers, examples could be:

    Negligible + Moderate = Medium
    (Column 1, list of values + Column 2, list of values = Column 3 Ė this value would just appear).

    There are 5 values in each of the list of values in columns 1 and 2, and there combination can equal a total of any 4 in column 3.

    I hope the above makes sense, and any help would be appreciated.

    Thanks,

  2. #2
    Registered User
    Join Date
    07-27-2006
    MS-Off Ver
    MS Office 2007
    Posts
    79
    hmmmm... sounds quite confusing...

    do you mind posting the possible combinations and answers? would make it easier to understand
    TL

    https://sites.google.com/site/teelim/
    My page of "not so useful" spreadsheets

  3. #3
    Registered User
    Join Date
    09-23-2006
    Posts
    3

    Smile Help with list of values

    Hi,

    No problems, I would be grateful for any help.

    The combinations can only be sourced from the matrix...

    Regards,
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by Billx
    Hi,

    No problems, I would be grateful for any help.

    The combinations can only be sourced from the matrix...

    Regards,
    In D3 put:

    =IF(ISERROR(INDEX(C$15:G$19,MATCH(B3,B$15:B$19,0),MATCH(C3,C$20:G$20,0))),"",INDEX(C$15:G$19,MATCH(B3,B$15:B$19,0),MATCH(C3,C$20:G$20,0)))

    and formula-fill that to D10



    ps, the colours are very pretty, and the legend is too, . . . but you need to fill the matrix with data, as per that shown on the legend.

    ---
    Last edited by Bryan Hessey; 09-24-2006 at 09:39 AM.

  5. #5
    Registered User
    Join Date
    09-23-2006
    Posts
    3

    Help with list of values - to Bryan Hessey

    Bryan,

    Cheers, I have filled the matrix with data and the formula worked in the table worked, this is appreciated.

    Does this allow for all of the combinations or do I have to edit any of the code?

    Again this is very much appreciated.

    Regards,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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