Hi, I am trying to make a drop down with multiple If function in data validation. But I couldn't make it. Please assist.
My requirement is based on N28 input in sheet1, it needs to refer table "MODEL" at list sheet.
Condition is if the N28 input is equal to B5 to B8, then dropdown to be provided with E5 & E6.
And if N28 input is equal to B9 to B12, then dropdown to be provided with F5.
Sheet (LIST 1)
Sheet 1
My requirement is based on N28 input in sheet1, it needs to refer table "MODEL" at list sheet.
Condition is if the N28 input is equal to B5 to B8, then dropdown to be provided with E5 & E6.
And if N28 input is equal to B9 to B12, then dropdown to be provided with F5.
Sheet (LIST 1)
Worksheet 3.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
2 | |||||||||
3 | |||||||||
4 | TYPE | SLEEVE | OTHERS | ||||||
5 | FSD | YES | NONE | ||||||
6 | FD | NO | |||||||
7 | SD | ||||||||
8 | CD | ||||||||
9 | LR | ||||||||
10 | ATN | ||||||||
11 | ND | ||||||||
12 | BD | ||||||||
13 | |||||||||
List |
Sheet 1
Worksheet 3.xlsx | ||||
---|---|---|---|---|
N | O | |||
26 | TYPE | SLEEVE | ||
27 | ||||
28 | FD | NO | ||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
O28 | Cell Value | contains "NO" | text | NO |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
N28:N89 | List | =TYPE |