Creating a primary and secondary Drop Down

[Corleone]

Im not sure whether im using the correct terminology here or whether im approaching it in the correct way ....

Im trying to create 2 dropdowns which are linked to each other i am doing this in "Sheet 1"

Sheet2 contains contains the raw data and i want to use 2 columns from this tab for the lists to create by Primary and secondary dropdowns
Column A Contains the Employee Name
Column B Contains the list of projects they are working on

I have created a list of the Employees in a hidden tab in order to create the primary Drop down because if i use the column A in sheet 2,the names of each individual appears multiple times as there hundreds of rows and each individual is listed mulitple times and i only want it to appear once in the drop down

When i select a name from this dropdown, i would like it then to make the secondary Drop down in Cell B1 filter so that it only allows you to select the projects that that individual is working on based on the data in Column B on sheet 2

any ideas?

Thanks

 

[RasGhul]

What version of Excel do you have?

 

[Corleone]

What version of Excel do you have?

365

 

[AhoyNC]

This link should help.

 

[Corleone]

This link should help.

Absolutely Spot on!

Cheers

 

[Corleone]

I can get the first part to work but im getting an #N/A error message when i try the Filter formula

=FILTER(Projects,Planners=POAP!A2)

 

[RasGhul]

Maybe

=FILTER(Projects,Planners=POAP!$A$2,"")

 

[Corleone]

Got it working now, i had some N/As in the source range so i pus an iserror in front of the vlookups that were generating the data at source and it all works now

Thanks all for your help

 

[AhoyNC]

Good deal, glad you got it figured out. Thanks for the feedback.