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?
Bookmarks