Lookup match index multiple values return other columns

Oops, my formula is completely "backwards"...

Follow Vlady's solution... it should work really well...

Make sure to still use my Column F and change Vlady's formula to find those...

Let us know if you still can't follow...

Thanks,
Dennis

PS problems with duplicates will always exist either with vlookups or index/match