+ Reply to Thread
Results 1 to 5 of 5

List of text from table based on multiple criteria

  1. #1
    Registered User
    Join Date
    09-15-2016
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    8

    List of text from table based on multiple criteria

    Hi all,

    I currently have an issue trying to produce a list of text based upon multiple criteria from a large table.

    I have a working solution based upon a single criteria, which is an array as follows:
    {=IF(ISERROR(INDEX(Complete!$A$2:$J$200,(SMALL(IF(Complete!$A$2:$A$200=$V$6,ROW(Complete!$A$2:$J$200)),ROW(1:1)))-1,3)),"",INDEX(Complete!$A$2:$J$200,(SMALL(IF(Complete!$A$2:$A$200=$V$6,ROW(Complete!$A$2:$J$200)),ROW(1:1)))-1,3))}

    This returns the text value in column 3 for each match in column a of the value in v6

    The issue i have is I want to do the same as above but only for when it match both column a to v6 AND column b to v7

    I have tried playing with the IF function but cant seem to land on the right formula to get things to work, can anybody suggest how to edit this please?

    Regards
    Jkaen
    Last edited by Jkaen; 09-15-2016 at 06:54 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: List of text from table based on multiple criteria

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    09-15-2016
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    8

    Re: List of text from table based on multiple criteria

    Ok Thanks, attached is the spreadsheet stripped down as much as I can, hopefully that makes it clearer
    Attached Files Attached Files

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: List of text from table based on multiple criteria

    Here:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-15-2016
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    8

    Re: List of text from table based on multiple criteria

    Perfect thanks

+ 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] take list of dates, and merge into larger table based on criteria
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-15-2016, 03:25 PM
  2. How do I populate a table based on multiple criteria
    By SMIengineering in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-12-2015, 02:14 PM
  3. [SOLVED] Match multiple criteria in table, create list
    By x65140 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2014, 12:21 PM
  4. Replies: 3
    Last Post: 12-03-2014, 05:43 PM
  5. Make a List from a table with multiple criteria
    By turist in forum Excel General
    Replies: 7
    Last Post: 04-22-2014, 12:31 PM
  6. Take whole parts of a list/table, based on one criteria?
    By Daniel86 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2013, 10:53 AM
  7. Replies: 2
    Last Post: 02-20-2012, 05:59 PM

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