Oct 17 2021 07:20 AM
I am an accountant using an Excel workbook to plan projects for team members. In the attached example, the "Tracker" tab lists the relevant project details (company name, year-end), and the "2022" tab, laid out in a rudimentary calendar, dictates the dates each team member should be working on each project.
I would like to return values in the "Tracker" columns of "Team Member", "Start Date" and "# Days" using formulas to essentially search for the "Identifier" values in the "2022" tab. I've played about with a few formula combinations such as INDEX, MATCH and XLOOKUP with no joy.
Any suggestions would be appreciated!
Oct 17 2021 07:37 AM
SolutionSee the attached version. If you don't have Microsoft 365 or Office 2021, you will have to confirm each of the formulas in row 2 with Ctrl+Shift+Enter, then fill down.
Oct 18 2021 05:14 AM
Oct 17 2021 07:37 AM
SolutionSee the attached version. If you don't have Microsoft 365 or Office 2021, you will have to confirm each of the formulas in row 2 with Ctrl+Shift+Enter, then fill down.