Formula to Search for Multiple Instances and Display All Data Related to Those Instances

Hello,

Is there an MS Excel formula that will search for a particular criteria, such as a certain name among a list of names, and for each instance of that one name that is found, all related data is populated into the formula cell?

For example -- The formula would search for Rick's name and then provide all of the food related to his name in one cell.

NAME:

col A col B
1 NAME FOOD
2 Bob Orange
3 Rick Apple
4 Dave Orange
5 Al Peach
6 Pete Orange
7 Rick Peach
8 Sam Nectarine
9 Rick Kiwi

Formula Result:
Apple
Peach
Kiwi

Thanks, Everyone!!!!

Happy Friday-Eve!

Rod

Thanks, Glenn!!

That works perfectly! You are AWESOME!!!

Rod