Index and Matching Possbilites Questions
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?
If you want all the matches returned to a single cell you'll have to use a VBA function to do that.Originally Posted by wadeingforgodot
Does your Mac version support VBA?
You can use formulas with built-in functions to return the matches to separate cells.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks