if with 3 options

[elynoy]

Hello, I'm trying to use if statement with 3 options with data validation. I got it to work with 2 but cant seem to figure how it will work with 3 or even if it's possible.

the code I have is

=SE(B5="yes";list1;list2)

based on the word "yes" but I'd like to add another option to that IF. I'd like to use those 2 lists or some value on another cell alone, let's say B6.

for exemple:

Cell B5 has "yes" and the cell D4, with the data validation, depending on the word, allows me to choose one of those 2 lists.
Cell B9 has another value, it's not a list, just a simple value "400".
I want cell D4 to let me choose those 2 lists or the value in B9


If anyone has a better way to do this would be even better.

Best regards,
eLy

 

[DanteAmor]

Cell B5 has "yes" and the cell D4, with the data validation, depending on the word, allows me to choose one of those 2 lists.
eLy

Something like this:

=SE(B5="yes";SE(D5="word1";list1;SE(D5="word2";list2,"no word")),"no yes")

 

[elynoy]

Thank you DanteAmor, I ended up using double dependent drop down menu. Found one working exemple of what I needed and it worked.

best regards,
eLy

 

[DanteAmor]

Thank you DanteAmor, I ended up using double dependent drop down menu. Found one working exemple of what I needed and it worked.

best regards,
eLy

I like knowing that you have a solution. Thanks for the feedback.