Hi all,
I am trying to create a formula that creates a sort of log of all my part time guys so i can pay them for the work i have done.
I have a work tracker spreadsheet that lists all the sales done and all the agents that have done them. What i want is a formula that searches the agents in say column C and if it matches a name in a table called PTAGENTS then it will fill in the information from column B(customer name), now this seems simple enough until you take into account that column C also has full time employees name which i dont need included and these part time agents could do multiple amounts of work in any given day which will differ the information in column B (customer name).
I hope that makes sense.
I am trying to create a formula that creates a sort of log of all my part time guys so i can pay them for the work i have done.
I have a work tracker spreadsheet that lists all the sales done and all the agents that have done them. What i want is a formula that searches the agents in say column C and if it matches a name in a table called PTAGENTS then it will fill in the information from column B(customer name), now this seems simple enough until you take into account that column C also has full time employees name which i dont need included and these part time agents could do multiple amounts of work in any given day which will differ the information in column B (customer name).
I hope that makes sense.