if with 3 options

elynoy

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

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,233
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
124
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
12,233
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,907
Messages
5,489,656
Members
407,703
Latest member
Chibuzo

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top