Restricting dropdown lists using VLOOKUP

Gopikrishna Mamidipudi · 08/01/18

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 · 08/01/18

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å · 10/17/18

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

Restricting dropdown lists using VLOOKUP

Comments

Help Article Resources

Categories