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
[TABLE="width: 200"]
<tbody>[TR]
[TD]ID[/TD]
[TD]KEY[/TD]
[/TR]
[TR]
[TD][TABLE="width: 246"]
<tbody>[TR]
[TD="class: xl65, width: 246"]240642,12345,82871[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 237"]
<tbody>[TR]
[TD="width: 237"]RT12347789[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 246"]
<tbody>[TR]
[TD="class: xl65, width: 246"]24312,12345,82872[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 237"]
<tbody>[TR]
[TD="width: 237"]RT12347790[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 246"]
<tbody>[TR]
[TD="class: xl65, width: 246"]24568,12345,82873[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 237"]
<tbody>[TR]
[TD="width: 237"]RT12347789[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 246"]
<tbody>[TR]
[TD="class: xl65, width: 246"]24568,12345,82873[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 237"]
<tbody>[TR]
[TD="width: 237"]RT12347792[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Table 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]RESULT[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]RT12347789,RT12347790,RT12347792[/TD]
[/TR]
[TR]
[TD]240642[/TD]
[TD]RT12347789[/TD]
[/TR]
[TR]
[TD]24568[/TD]
[TD]RT12347789, RT12347792[/TD]
[/TR]
[TR]
[TD]24312[/TD]
[TD]RT12347790[/TD]
[/TR]
</tbody>[/TABLE]


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