Forum Discussion
Creating a list of projects based on who worked on it
Hi everyone, I have a worksheet similar to the below only WAY bigger in each direction. What I would like to try to accomplish if it's possible is to create a dropdown list of all the "Compan...
Let's say your worksheet is named Project Sheet.
On another sheet, you create a drop-down list in A1 that lists all company IDs.
In B1, enter the formula
=FILTER('Project Sheet'!$B$1:$ZZ$1, INDEX('Project Sheet'!$B$2:$ZZ$1000, MATCH(A1, 'Project Sheet'!$A$2:$A$1000, 0), 0)="Y", "")
That's amazing, Thank you very much for that. I really appreciate it.