Hey guys,

I have a list of agents on a spread sheet called "Agents" and I want to search a worksheet called "MASTER" to find the clients represented by the agent.

The idea:
On Agents sheet in F2 I would write a formula like "Look up vale A2 in sheet "MASTER" search column P (fir the agent name), return values in column B that match separated by commas"

Any ideas?