Restricting dropdown lists using VLOOKUP

Gopikrishna Mamidipudi

Depending on values in one column I want to restrict the dropdown list in another column

Example: I have a sheet: Employees

Role            Name

------            -------------

PM              Jane

PM              John

Dev            Mark

Dev             Stephanie

In another sheet where Tasks I have these same two columns

Role and Name

Once I enter the Role (say PM) it should automatically reduce my dropdown list in the Name Column to (Jane and John).

 

Is this possible?

 

J. Craig Williams

No. 

With a small set of Roles, you could split them out into their own columns, but that opens up even more problems.

Craig