Lookup
- Thread starter FVFO
- Start date
AlanSidman
Well-Known Member
It appears that you are duplicating the results in your example. Is this what you want. How many repeats? Instead of a picture, please post a sample workbook uploaded. I am lazy and dont really want to copy your data to solve your issue. Help us to help you by giving us something to work with and not create work for us.
FVFO
New Member
Thanks for replying back to me,
Im basically trying to create a work distribution list, but havent found a solution on my own or with help from other forums, hope you can help.
See attached document, on AR DistributionF sheet i made a table to figure out how many accounts will be assigned per month, usually have between 5 to 10 agents and supervisor decides how many accounts to assign per day to each person on the team, if someone asked for vacation no accounts will be assigned on that date, i worked this out by making a calendar table to figure out total accounts in the month and used vlooup to get a number which corresponds to the date on the calendar table, if an agent asks for date off i just delete the value where agent number and date intersect.
More info on what im looking for in the attached document
Im basically trying to create a work distribution list, but havent found a solution on my own or with help from other forums, hope you can help.
See attached document, on AR DistributionF sheet i made a table to figure out how many accounts will be assigned per month, usually have between 5 to 10 agents and supervisor decides how many accounts to assign per day to each person on the team, if someone asked for vacation no accounts will be assigned on that date, i worked this out by making a calendar table to figure out total accounts in the month and used vlooup to get a number which corresponds to the date on the calendar table, if an agent asks for date off i just delete the value where agent number and date intersect.
More info on what im looking for in the attached document