Hi,
Advance apologies if this has been solved elsewhere as I may not have searched for the correct wording.

I am looking for a way to do a look up on 1 column that may have duplicate entries and return all results for a match (not just the first one).


I.e. based on below example, I need to find a way to lookup on column A (the fruit) and return all of the matches for this look up from column B (the colours):

Banana Blue
Apple Blue
Banana Red
Pear Yellow
Banana Yellow

So I am looking to return in 3 separate fields:
Banana Blue Red Yellow

Hope this is clear.

Many thanks in advance!