Good morning,
I am stuck with a formula that I am trying to use to complete a dashboard showing which projects our partnership organisations work on with us. I have attached a spreadsheet with two example tabs:
1. Master List
This is the worksheet our team uses to add partnership details. The last 5 columns are used to indicate (with a 'Y') which of our key projects each partner is involved with.
2. Dashboard
The table I have added here shows the names of the partners, pulled through from the Master List, but what I really need is a formula that will also bring over the projects that they are involved with from the Master List (Columns O to T). This will populate my Partners by Project table in the Dashboard. Is it worth using a formula, or would a Pasted Link be able to do this adequately?
Bookmarks