Restricting dropdown lists using VLOOKUP
Depending on values in one column I want to restrict the dropdown list in another column
Example: I have a sheet: Employees
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?
Help Article Resources
Check out the Formula Handbook template!