3 dependent drop downs

[pyclen]

Hi there,

I do have an issue creating dependent drop downs. I need a total of 3 dropdowns.
The 1st is the Offering (NCE, Generic, Commercial) where there are 3 choices, then based on the selection of the Offering a number of technologies are shown in the 2nd dropdown, and lastly based on that 2nd dropdown a rate is displayed in the 3rd dropdown.
I can clobber something together w/2 dropdowns but then it leaves me behind. Any help is appreciated.
The table in columns H & I can also be horizontal over 6 columns.

Example: if you choose NCE, Technology 1 the rate is 200

any help is greatly appreciated

Book1
	B	C	D	E	F	G	H	I	J	K	L
1
2	Offering drop down	Technology dropdown	Rate dropdown				NCE	rate			NCE
3							Technology 1	200			Generic
4							Technology 2	240			Commercial
5							Technology 3	278
6							Technology 4	200
7							Technology 5	325
8							Technology 6	150
9
10							Generic	rate
11							Tech 1	300
12							Tech 2	222
13							Tech 3	245
14							Tech 4	216
15							Tech 5	357
16							Tech 6	234
17
18							Commercial	rate
19							something 1	123
20							something 2	125
21							something 3	130
22							something 4	135
23							something 5	140
24							something 6	147
Sheet1

Cell Formulas
Range	Formula
L2	L2	=H2
L3	L3	=H10
L4	L4	=H18

Cells with Data Validation
Cell	Allow	Criteria
B3:B5	List	=offering

 

[pyclen]

Ok, thank you, will try these

appreciate the input