Joseph Horling
Member
Hi Chandoo Experts,
On my payroll project, I am trying to use the index/match function to display the summary of each category for each employee on the employee dashboard. I have used the index/match/match to look up my name with the three dates that are associated with it. That seems to work, but I am not sure how to do it for the other names. Keeps on saying na. Granted, I have only used my name and part of Mallory's name for the date of 10/10/2019 on the employee summary. If you could take a look at it and notice anything that I am doing wrong, I would appreciate it. Thanks for your help as always. Joe, Michigan. P.S. Let me know if you need any more information regarding on what I am trying to do.
On my payroll project, I am trying to use the index/match function to display the summary of each category for each employee on the employee dashboard. I have used the index/match/match to look up my name with the three dates that are associated with it. That seems to work, but I am not sure how to do it for the other names. Keeps on saying na. Granted, I have only used my name and part of Mallory's name for the date of 10/10/2019 on the employee summary. If you could take a look at it and notice anything that I am doing wrong, I would appreciate it. Thanks for your help as always. Joe, Michigan. P.S. Let me know if you need any more information regarding on what I am trying to do.
Attachments
Last edited by a moderator: