How do we using dynamic list based on condition criteria from cell value?

[riyajusg]

We using dropdown dynamic list from master using OFFSET function for except blank data's,
Here, we would like to next two columns lists should allow/block based on the previous column list value, Kindly help us anyone, how to do this functions in excel?

Eg:

In above example,
First List, Should not be REMOTE LOCATION, then only the user allow to access next column lists, (OR) user should not allow to access other two columns, If Venue column list value is equal to "Remote Location" (Like red marked)
Attn: (All the Columns are Dropdown Lists - comes from Master Sheet = dynamic list using formula like =OFFSET(MASTER!$D$2,0,0,COUNTA(MASTER!$D:$D),1))

 

[JamesCanale]

MrExcelPlayground.xlsm
	K	L	M	N	O	P	Q	R	S	T	U
7	Remote Location
8	Area 1
9	Area 2
10
11
12	Area 1	Van	Company		Van	Bike	Car		Group	Company	Event
13	Remote Location
14	Area 2	Bike	Event		Van	Bike	Car		Group	Company	Event
15	Remote Location
16	Area 1	Car	Group		Van	Bike	Car		Group	Company	Event
17	Remote Location
Sheet39

Cell Formulas
Range	Formula
O12:Q12,O16:Q16,O14:Q14,O13,O15,O17	O12	=IF(K12<>$K$7,{"Van","Bike","Car"},"")
S12:U12,S16:U16,S14:U14,S13,S15,S17	S12	=IF(K12<>$K$7,{"Group","Company","Event"},"")
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L12:M17	Expression	=$K12="Remote Location"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
K12:K17	List	=$K$7:$K$9
L12:L17	List	=$O12:$Q12
M12:M17	List	=$S12:$U12

This uses some conditional formatting to color the 'remote location' cells red, and the drop downs will contain no information to select there. It works by having the rows of lookups for the drop down based on the first selection. Those rows of lookups should be put somewhere else out of the way.