How to best pull data from a matrixed sheet of dates and milestones into a project sheet?
Options
RFornasiero
✭✭
I have a team that is updating date estimates in a large sheet. I'm looking to create a project sheet from that matrix/range. I'd like generate the sheet with links at the same time so that when the team revises dates in their sheet the project sheet updates as well. I don't want to have to manually create Column A entries and 1000+ links in Column B (See attached example)
Does anyone have a silver bullet or advice?
Thanks!
Answers
-
You need to add 2 helper column and use a vlookup or index match formula
-
Thank you, @elicos ! I'll give this a try.
