Hello all,
I have tried all sorts of ways to get this puppy to work but come up shorthanded each time.
Firstly let me explain what I am trying to accomplish.
I have an excel spreadsheet - 2 tabs. One tab is "Agent Sheet" in which I have columns:
Date, Agent Name, Code, Time, Comments, Occurrence Points
On tab 1, I need to find a way so that I can write an agents name and have it return below each row that contains their name on the "agent sheet" tab.
The endgame is a way to keep track of attendance points.
Firstly I tried the following resource:
Vlookup Multiple Values - Return MULTIPLE corresponding values for ONE Lookup Value
It would return most of the correct rows but always throws in a row that doesn't belong to that agent.
Also using that formula provided in each of the columns I am looking to pull over really slowed down the spreadsheet. When changing the lookup value field (agent name to lookup) it would almost freeze the whole spreadsheet.
In summary this is what I am trying to achieve:
-Insert agent name into cell
-Below this cell a log appears that shows each time an agent was late, absent, etc.
Any help in getting me past that initial point where I'm stuck at would be very appreciated!
I have tried all sorts of ways to get this puppy to work but come up shorthanded each time.
Firstly let me explain what I am trying to accomplish.
I have an excel spreadsheet - 2 tabs. One tab is "Agent Sheet" in which I have columns:
Date, Agent Name, Code, Time, Comments, Occurrence Points
On tab 1, I need to find a way so that I can write an agents name and have it return below each row that contains their name on the "agent sheet" tab.
The endgame is a way to keep track of attendance points.
Firstly I tried the following resource:
Vlookup Multiple Values - Return MULTIPLE corresponding values for ONE Lookup Value
It would return most of the correct rows but always throws in a row that doesn't belong to that agent.
Also using that formula provided in each of the columns I am looking to pull over really slowed down the spreadsheet. When changing the lookup value field (agent name to lookup) it would almost freeze the whole spreadsheet.
In summary this is what I am trying to achieve:
-Insert agent name into cell
-Below this cell a log appears that shows each time an agent was late, absent, etc.
Any help in getting me past that initial point where I'm stuck at would be very appreciated!