How to reference a cell to get multiple data in a named range

[SanctiMortem]

Hi,

I've been trying to find anything related to my question but all I get is multiple results that match the same reference. Ex. If a have [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Color[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD]Green[/TD]
[/TR]
[TR]
[TD]Dave[/TD]
[TD]Red[/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD]Red[/TD]
[/TR]
</tbody>[/TABLE]

I would look for red and I would get "Dave" and "Matt".

What I am looking for is:

If I have several lists like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]John[/TD]
[TD]Dave[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Green[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Purple[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]Potato[/TD]
[/TR]
</tbody>[/TABLE]
each of the lists is named ranged to the name so, blue, red yellow cells are named "John".
And I need to be able to look for John and get the "blue, red, yellow" as a result. and if I look for Dave I get "Green, purple, potato"
Each list can be smaller or larger than the other, and each name has a completely different list. I already have a index-match to find all the information about that name, except for this part, which I can't figure out how to do it.

Please any help would be greatly appreciated!! thank you!!