+ Reply to Thread
Results 1 to 2 of 2

Vlookup multiple terms in one cell, and output corresponding results into a single cell

  1. #1
    Registered User
    Join Date
    03-01-2021
    Location
    US
    MS-Off Ver
    ms office 365
    Posts
    1

    Vlookup multiple terms in one cell, and output corresponding results into a single cell

    Hi,
    I am trying to Vlookup multiple terms in one cell, and output corresponding results into a single cell (comma separated) again.

    Table A ( mapping table)

    HAQ external id
    HAQ system id
    HAQ1 HAQ00001
    HAQ2 HAQ00002
    HAQ3 HAQ00003
    HAQ4 HAQ00004
    HAQ5 HAQ00005
    HAQ6 HAQ00006
    HAQ7 HAQ00007
    HAQ8 HAQ00008
    HAQ9 HAQ00009
    HAQ10 HAQ00010



    Table B ( lookup 1st column of comma separated values from Table B and mapping table A and return comma separated values in 2nd column in Table B in bold italic)

    Related HAQs(external id)
    Output HAQ system id comma separated
    HAQ1,HAQ2,HAQ3,HAQ4,HAQ5,HAQ6,HAQ7,HAQ8,HAQ9,HAQ10 HAQ00001,HAQ00002,HAQ00003,HAQ00004,HAQ00005,HAQ00006,HAQ00007,HAQ00008,HAQ00009,HAQ00010
    HAQ11,HAQ12,HAQ13,HAQ14,HAQ15,HAQ16,HAQ17,HAQ18,HAQ19,HAQ20 HAQ00011,HAQ00012,HAQ00013,HAQ00014,HAQ00015,HAQ00016,HAQ00017,HAQ00018,HAQ00019,HAQ00020


    Any help will be much appreciated.
    Thanks
    Last edited by mk5331981; 03-01-2021 at 04:37 PM.

  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,888

    Re: Vlookup multiple terms in one cell, and output corresponding results into a single cel

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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

+ 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. VLOOKUP to return multiple unique results in a single cell
    By EvolutionJulie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-09-2020, 11:50 AM
  2. [SOLVED] Cell results based off multiple other cell output
    By LShepherd in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-17-2016, 01:34 PM
  3. Compare values and output cell titles, able to output multiple results
    By TMG2016 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-07-2016, 11:42 AM
  4. [SOLVED] vLookup multiple values separated by ";" in single cell / return result in single cell
    By Tunesmith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2015, 12:02 PM
  5. Multiple [BRACKETED TERMS] on multiple related rows to single comma seperated cell
    By fau5tu5 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-08-2015, 05:31 AM
  6. To get multiple output from a Vlookup in a single cell
    By Murthi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2011, 07:11 AM
  7. [SOLVED] Can multiple cell results be displayed in a single cell?
    By FuadsCurse in forum Excel General
    Replies: 3
    Last Post: 05-18-2005, 01:06 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