Multiple IF function in Data validation

[IDRIS86]

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)

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

 

[kweaver]

You said it was to be a dropdown:

 

[IDRIS86]

You said it was to be a dropdown:

View attachment 35476

Hi Thanks. But only N28 is located in Sheet 1 and other referred cells are in other sheet (List). Guess I need to fix the cells with $.

 

[IDRIS86]

You said it was to be a dropdown:

View attachment 35476

Is it working for you .

 

[kweaver]

Yes, it's working for me or I wouldn't have sent it to you.

 

[kweaver]