+ Reply to Thread
Results 1 to 3 of 3

Pull a sub list of info from a column based on multiple critiria in 2 other columns

  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Pull a sub list of info from a column based on multiple critiria in 2 other columns

    I would like to pull a sub-list from Col B when Col C matches specific criteria and when Col D matches multiple specific Critiria and put the sublist in Col A.
    Example
    ColA | ColB | ColC | ColD
    a | a | 1 | s
    c | b | 2 | t
    e | c | 1 | u
    g | d | 2 | v
    | e | 1 | w
    | f | 2 | s
    | g | 1 | u
    | h | 2 | w
    where ColC must match 1 and ColD must match s, u, or w
    Any help would be greatly appreciated.
    Attached a sample to play with.
    Best,
    ExcelFalcon
    Attached Files Attached Files
    Last edited by ExcelFalcon; 07-27-2018 at 11:16 AM. Reason: Solved

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Pull a sub list of info from a column based on multiple critiria in 2 other columns

    in H2
    =IFERROR(INDEX($B$2:$B$9,SMALL(IF(($C$2:$C$9=1)*((D$2:D$9={"s","u","w"})),ROW($A$2:$A$9)),ROW(A1))-(ROW(A$2)-1),1),"")
    Array formula, use Ctrl-Shift-Enter
    and copy down for as many rows in column B
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    06-08-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Pull a sub list of info from a column based on multiple critiria in 2 other columns

    Exactly what I was looking for thank you!
    I placed it in A2 instead of H2.

+ 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] Formula to sum based off critiria in one column
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2016, 05:50 PM
  2. Replies: 1
    Last Post: 02-10-2016, 11:26 AM
  3. Vlookup/Match: pull info from multiple columns
    By excellerant8 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2014, 05:09 PM
  4. Conditional Formatting in Pivot based on Multiple Critiria
    By JohnMaier in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2013, 03:41 PM
  5. Replies: 2
    Last Post: 10-25-2013, 07:01 PM
  6. Pull Data from Multiple Columns Based On Data Validation List Selection
    By CHRISOK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 11:41 PM
  7. Pull data from different columns based on info in column "A".
    By PowerSchoolDude in forum Excel General
    Replies: 2
    Last Post: 08-25-2009, 03:25 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