I am trying to write a function with INDEX,MATCH. I have attached a sample worksheet for an example. My first worksheet "employee stats" lists all employees and their number of clients. The adjacent worksheets list the employees separate with a detailed listing of their client load. What I am trying to do is take the total # of clients in sheet 2 (employee 1) which would be cell B22 and have it automatically populate on sheet 1 (employee stats) into the appropriate cell, which in this case for employee 1 would be C4 for current month for employee 1. I hope this makes sense as I have been beating my head against the wall! Thanks in advance for any help you can offer! Thanks so much!!
Bookmarks