How to make a condition in a cell to pull up a list of elements?

Question

Google

good afternoon.
Can you please tell me how to make a condition in a cell that if the element "examination" is in the next cell, then such a list will appear (i.e., a range of cells combined into a list) and if the element is "development", then the second list?

Answer 1

As I understand it, this will help you too)
How to set up a change in the drop-down list in a cell when an element is selected from the first drop-down list in Google Docs Spreadsheets?

I just recently solved it like this)
(I did support for two language interfaces)
Created a drop-down list on the charlist page in cell B1: Russian, English
On another sheet (language) set two columns one with Russian value. Another corresponding English
For example:
gnome / gnom
Orc / Orc
Man / human
On another sheet, I created a line in which the language is checked by if and thereby selects the desired value. (race or race, etc.)
Next, I named this line with the races as the race range
And created a drop-down list with the race range.
Result: When you select a language, the drop-down lists dependent on it change as well.
In the case of 3 options, 2 ifs are needed. And another column

IF(Charlist!$B$1="English";language!$B9;IF(Charlist!$B$1="français";language!$С9;language!$A9))

Answer 2

There is a more different way, but it works 100%
if the topic is relevant, write and sign