Update: Project list by department. Pulling the list from another tab.

I have this simple spreadsheet I am using to track capital projects with the city I work for. on the first tab "Raw Data." I have all the info about all the projects. The second tab "Report" is a simple report using vlookups to return specific information about each project. The third tab "Dept. Summary" is giving me some grief.

I want to list all the projects and their funding sources by each department here. I want a formula to look at the Raw Data tab and find all the projects that the specific department has, and list them in the highlighted area. Since the Raw Data tab is constantly being added to, this formula would need to always be looking for new projects.

Is something like this even possible? If there are questions, let me know. Thanks!

This would require a detailed macro, no formulas are going to get you a formatted report like this, not with an expanding data sheet of unknown length.

If it were a set length would it be possible? The formula would look at the dept name (Administration, Public Works, etc.) and then list all the projects that it finds. If I wanted to just return one project, a could just use a vlookup, like on the "report" tab, but I want to list all the projects.

Edit: I'm wondering now if I could use filtering to get a similar result.

Since this is a static layout, this becomes pretty easy. I've added a "key" column to your raw data to make the lookup of each item simple.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.