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

Andrée Starå

Hi,

This might be helpful!

Here is a workaround that gives you the possibility to use lists of information and choose from that list inside a sheet (doesn't work with mobile, only desktop)

I'm utilizing cell-linking for this workaround. The main sheet is linked to the dropdown/list sheet.

Please see the attached link/screenshot for more information.

Example of dropdown/list

I hope this can be helpful for you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting