lookup by comma delimited list with single value list

[cerchiarax]

Hi guys,

I've been trying to get a solution my self and I searched the thread and found the following below that partially got what I was after.

https://www.mrexcel.com/forum/excel-questions/546013-find-value-cell-comma-delimited-list.html


https://www.mrexcel.com/forum/excel...-separated-list-pull-cell-value-same-row.html

Below I have 2 tables, I'm looking to match the table 1 "ID" that is comma delimited with the single "ID" that is in Table 2. So that I could get all the "KEY'S" that are in Table 1 that match with these ID's to look like the "RESULT" Column that I manually created in table 2.

Table 1

ID	KEY
240642,12345,82871 <tbody> </tbody>	RT12347789 <tbody> </tbody>
24312,12345,82872 <tbody> </tbody>	RT12347790 <tbody> </tbody>
24568,12345,82873 <tbody> </tbody>	RT12347789 <tbody> </tbody>
24568,12345,82873 <tbody> </tbody>	RT12347792 <tbody> </tbody>

<tbody>
</tbody>

Table 2

ID	RESULT
12345	RT12347789,RT12347790,RT12347792
240642	RT12347789
24568	RT12347789, RT12347792
24312	RT12347790

<tbody>
</tbody>

Thanks ahead of time with any help you guys can provide.

 

[cerchiarax]

Awesome Fluff, the new code worked and the #VALUE ERROR is gone now. Thanks!

 

[Fluff]

Glad to help & thanks for the feedback