I am creating a master spreadsheet and need some formula help.
I am trying to pull through names of employees based on if they have a value against a project
A,B,C are three projects on three seperate tabs. Person D,E,F are employees. Person D and F have logged time against Project A.
On the master sheet i have a created a column of projects (A,B,C) and want to pull through the names (D,E,F) if they have any values against the project below the relevant project. How do i do this?
Below is a link to the spreadsheet.