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

Name	Color
John	Green
Dave	Red
Matt	Red

<tbody>
</tbody>

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

John	Dave
Blue	Green
Red	Purple
Yellow	Potato

<tbody>
</tbody>

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!!