Return column/row heading based on location of text found

New Contributor

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!

2 Replies
best response confirmed by PMMMSH (New Contributor)


See 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.

Amazing! Thank you for your swift assistance!