Excel guru in here for some help please.

[Colbaker]

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.

 

[namnoc]

It would look truly complicated in a formula, but would be simple to write as a VBA script.

If you decide what you want where, make the spreadsheet exactly how you want it, write down what has to go in the missing boxes and email it to me, I will send it back with the VBA bit added.