Results 1 to 11 of 11

Vlookup and concatenate results - possible with formulas?

Threaded View

  1. #3
    Registered User
    Join Date
    11-21-2012
    Location
    Spain
    MS-Off Ver
    Excel Mac 2008
    Posts
    14

    Re: Vlookup and concatenate results - possible with formulas?

    Thank you Glenn!

    I attach an Excel file with a more real list.
    It's in fact a list of writers signing books at bookshops. (it's St George day in Catalonia, a books festival)

    I see your formula works if there are just 2 destinations and doesn't show nothing if there is a different number.

    Our main problem is that the list is a work in progress. Editors and authors are sending new data every day, that we add to a master Excel file.
    So we don't know how many 'authors' ('origin' column in the OP example) and 'places' (originally 'destinations') we will have in the end.

    Thanks for your help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Concatenate Multiple Vlookup/Index/Match Results with Commas
    By mkay13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-29-2015, 02:04 PM
  2. Replies: 6
    Last Post: 06-11-2014, 12:54 AM
  3. [SOLVED] Need Formulas to Hide Partial Concatenate Data and Help Determining Two Other Formulas
    By Mattdim805 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2013, 04:11 PM
  4. concatenate listbox results in textbox
    By rickdaw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2012, 05:46 PM
  5. split text,use in vlookup and concatenate results
    By reghu in forum Excel General
    Replies: 7
    Last Post: 09-07-2010, 07:05 AM
  6. I can't get my concatenate formula results to show
    By Lauren in forum Excel General
    Replies: 3
    Last Post: 11-18-2005, 01:00 PM
  7. Concatenate VBA results and an * in a cell
    By Werner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-30-2005, 12:04 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