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):
So I am looking to return in 3 separate fields:
Banana Blue Red Yellow
Hope this is clear.
Many thanks in advance!