generating named data based on values

  • Hi Guys

    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

    For example

    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.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!