+ Reply to Thread
Results 1 to 3 of 3

Vlookup and Concatenate or INDEX/MATCH and Concatenate

  1. #1
    Registered User
    Join Date
    04-13-2020
    Location
    Texas, United States
    MS-Off Ver
    Office 10
    Posts
    5

    Vlookup and Concatenate or INDEX/MATCH and Concatenate

    Hi folks,

    I have the following in Sheet1

    Data 1 Data 2
    A Alpha
    A Beta
    A Charlie
    B Delta
    B Echo

    And this in Sheet2

    Data 1 Result
    A Alpha-Beta-Charlie
    A Alpha-Beta-Charlie
    A Alpha-Beta-Charlie
    B Delta-Echo
    B Delta-Echo

    Columns As in both sheet are identical and I'd like to concatenate as shows in result column of 2nd sheet.

    Thanks
    Khan

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,753

    Re: Vlookup and Concatenate or INDEX/MATCH and Concatenate

    Using Power Query, here is the Mcode for your issue.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-13-2020
    Location
    Texas, United States
    MS-Off Ver
    Office 10
    Posts
    5

    Re: Vlookup and Concatenate or INDEX/MATCH and Concatenate

    Works like a charm, thank you so much

+ 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] 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. Match Index and Concatenate Formula
    By kharding15 in forum Excel General
    Replies: 4
    Last Post: 10-02-2015, 09:01 PM
  3. Why does concatenate work with Vlookup but not Index match
    By vitt4300 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2015, 01:41 PM
  4. Vlookup or Index Match multiple criteria with Concatenate
    By mpost54 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2015, 05:22 PM
  5. Help Using Concatenate with Index Match
    By billyshears in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-25-2013, 10:09 AM
  6. [SOLVED] Index, Match and Concatenate
    By mmayna03 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2012, 09:55 PM
  7. [SOLVED] INDEX-MATCH w/ CONCATENATE
    By zamgold in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-25-2012, 11:08 AM

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