+ Reply to Thread
Results 1 to 4 of 4

Returning Multiple Values Separated by Commas to a single cell

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    San Francisco CA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Returning Multiple Values Separated by Commas to a single cell

    Hi excel gods,

    I am trying to consolidate a table with multiple contacts. See below

    Company Contact
    XYZ McClintock, Brad
    XYZ Johnston, Sarah
    ABC Brady, John
    ABC Pelosi, Nancy
    ABC Baird, Kyle
    TUV Monty, Katy

    I'm hoping to be able to match text in the "Company" column with the contact column (multiple matches) like in the example below:

    Company Contacts
    XYZ McClintock, Brad, Johnston, Sarah

    Sort of like a Vlookup but for multiple matches. So the lookup value would be XYZ and the matches would be McClintock,Brad and Johnston, Sarah (both names hopefully to appear in the same cell)

    Any help is appreciated, I'm stuck!!

    Thanks so much,
    Steph

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Returning Multiple Values Separated by Commas to a single cell

    With an helpcolumn.

    After that index / match.

    See the yellow cells in the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    03-04-2013
    Location
    San Francisco CA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Returning Multiple Values Separated by Commas to a single cell

    You are ******* awesome!! Thank you!!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Returning Multiple Values Separated by Commas to a single cell

    Thanks for the reply.

    Glad I could help.

    You can add rep(utationpoints) to the members who helped you by clicking on the star on the left side.

+ 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 count values in single cell separated by commas
    By aimeecrystalaid in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-25-2017, 01:01 AM
  2. vlookup multiple values in single cell separated by spaces
    By aimeecrystalaid in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 12-15-2013, 10:23 PM
  3. Replies: 5
    Last Post: 11-22-2013, 05:58 PM
  4. [SOLVED] How do I combine multiple lines of information into a single cell, separated by commas?
    By ilostar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2012, 11:48 AM
  5. Replies: 5
    Last Post: 06-05-2012, 03:32 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