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

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.