+ Reply to Thread
Results 1 to 2 of 2

Same VLOOKUP value for multiple rows; Need to combine info from one cell in each row

  1. #1
    Registered User
    Join Date
    08-05-2019
    Location
    Temecula, CA
    MS-Off Ver
    Windows 10
    Posts
    3

    Exclamation Same VLOOKUP value for multiple rows; Need to combine info from one cell in each row

    Hello Everyone!

    First, let me say that this place is amazing! I posted once before this and the solution I had been seeking for over an hour was solved in 10 minutes. You guys are awesome! So, I'm hoping for a similar outcome here.

    The worksheet has unique values (GES101, GES 102, GES103, etc...) in column D. This is my lookup value for a VLOOKUP (Could use Match, Index as well; open to anything). I have multiple rows with these values. For example, I have two rows with a value of GES121 in column A; two rows with a value of GES148, 3 rows of GES152, and so on. The Rows don't go higher than 6 for each unique value, but I have about 500 rows containing unique values going up to GES890.

    The values I need are all contained in one column (Column B). So I need a formula that will pull all the values for GES101, GES102, etc...then combine these values into one cell, each separated by a comma.

    I hope I explained this adequately. Please feel free to ask questions and please look at the attachment to get a better idea. Thanks!
    Attached Files Attached Files
    Last edited by stephen.arnold1261; 09-06-2019 at 10:09 AM.

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

    Re: Same VLOOKUP value for multiple rows; Need to combine info from one cell in each row

    Oops, pls ignore this, I replied to wrong thread.
    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.

+ 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] Combine Multiple Rows into single cell
    By 1brandeja5 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-29-2016, 06:02 PM
  2. How to Combine (Concatenate) Data from Multiple Rows into One Cell
    By syed82 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-02-2015, 04:38 AM
  3. [SOLVED] VLookup a specific # in a cell that contains multiple #s...then paste row info
    By marshak in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-21-2013, 11:11 PM
  4. Need help copying info from multiple rows to one cell....
    By haven9270 in forum Excel General
    Replies: 5
    Last Post: 11-14-2012, 12:32 PM
  5. Replies: 1
    Last Post: 09-13-2011, 04:33 PM
  6. Replies: 3
    Last Post: 04-15-2010, 08:36 PM
  7. [SOLVED] combine multiple values in a table into one cell using vlookup?
    By Liam S. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-27-2006, 04:25 PM

Tags for this Thread

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