CheekyDevil
New Member
- Joined
- Apr 15, 2018
- Messages
- 20
Hey all,
I'm in desperate need for a code that will allow the return of multiple values from a line of cells (of which I can then CONCATENATE) using a given criteria.
For context, my headings are:
A1 = Date B1 = Agent C1 = TL D1 = Type E1 = Ref# F1 = Comments
What I need is a code that allows me to enter a TL name in a cell (say L1 to keep it out of the way), and return all the agents and corresponding data from A to F that have this TL in the data range (A1:F5000)
Then (if possible) if I can further narrow it down to return the result of all items from a particular agent (name entered in K1), for example, all data from Dave (agent) in Allen's team (TL).
I've tried using an INDEX + MATCH combination but as it turns out I'm not at this level to understand this formula just yet HAHA
Thank you for any help you can provide![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I'm in desperate need for a code that will allow the return of multiple values from a line of cells (of which I can then CONCATENATE) using a given criteria.
For context, my headings are:
A1 = Date B1 = Agent C1 = TL D1 = Type E1 = Ref# F1 = Comments
What I need is a code that allows me to enter a TL name in a cell (say L1 to keep it out of the way), and return all the agents and corresponding data from A to F that have this TL in the data range (A1:F5000)
Then (if possible) if I can further narrow it down to return the result of all items from a particular agent (name entered in K1), for example, all data from Dave (agent) in Allen's team (TL).
I've tried using an INDEX + MATCH combination but as it turns out I'm not at this level to understand this formula just yet HAHA
Thank you for any help you can provide
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)