Hi All,
I am working on a task where i have to populated the project timesheet for each resource based on the invoice data. First half of the task, i was able to achieve using Uipath. on the second half, since i felt it was complex to do Uipath i started adding formula in excel.
Please find the attached template excel where i have used Index match formula which is currently working for Nov.
But when i change From: value(First of the Month) in B5 , C12:A13 get re-arranged which is screwing up the formula.
How do i dynamically build the index match formula in this scenario? Please advice.
I am attaching my template sheet here.
Bookmarks