if with 3 options

elynoy

Board Regular
Joined
Oct 29, 2018
Messages
122
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
Code:
=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

Well-known Member
Joined
Dec 3, 2018
Messages
9,767
Office Version
2007
Platform
Windows
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

Board Regular
Joined
Oct 29, 2018
Messages
122
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

Well-known Member
Joined
Dec 3, 2018
Messages
9,767
Office Version
2007
Platform
Windows
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.
 

Forum statistics

Threads
1,086,204
Messages
5,388,395
Members
402,115
Latest member
ypompoms

Some videos you may like

This Week's Hot Topics

Top