+ Reply to Thread
Results 1 to 2 of 2

INDEX & MATCH multiple rows to return comma separated cell

  1. #1
    Registered User
    Join Date
    02-18-2015
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    1

    INDEX & MATCH multiple rows to return comma separated cell

    Trying to create a comma separated cell with values from column A by matching a string in column B:

    A B
    Item1 X
    Item2 Y
    Item3 Z
    Item4 Z
    Item5 Y
    Item6 Z

    Say I want to get all the items in column A that has a "Z" in column B. How can I make a formula that would return:

    Item3, Item4, Item6

    Here's what I tried, but can only return the 1st item (Item3):

    =INDEX(A1:A6,MATCH("Z",B1:B6,0))

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: INDEX & MATCH multiple rows to return comma separated cell

    If A1:B6 holds your data, and C1 holds your lookup letter (Z, Y, X), paste this into D1 and drag down to match your range of data in columns A or B:

    Please Login or Register  to view this content.
    Confirm with CSE.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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. Replies: 8
    Last Post: 01-16-2015, 12:16 PM
  2. Match a Value from a single-cell, comma separated list
    By secondchild12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-24-2014, 06:16 PM
  3. Search cell for multiple text , return comma separated text in separate cell if found
    By dangerdoug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2013, 01:52 PM
  4. Combine multiple rows into one comma separated column
    By NotAvg1 in forum Excel General
    Replies: 9
    Last Post: 03-04-2013, 07:06 PM
  5. Return Y/N after matching from multiple lookup values separated by comma
    By indoglans in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2011, 03:13 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