Different validation list based on cellvalue on the left

[Guest]

Hello, I have a list with values,
I want to create validation list for each cell depending on value in cel
[A]
[A] [D] [E] [F]
[G]
[1] DI16 select from [D1]:[F1] DIa DIb DIc
[2] DO16 select from [D2]:[F2] DOa DOb DOc
[3] DI4 select from [D3]:[E3] DIa DIb
[4] AI1 select from [D4]:[G4] AIa AIb AIc AId

The values in [D] through [G] are calculated

Can some one help me with this, Cause I'm getting stuck

THanks a lot in advance

 

[Ron Coderre]

See Debra Dalgleish's coverage of Dependent Lists at her website:

http://www.contextures.com/xlDataVal02.html

Does that help?
----------------------

Regards,

Ron
Microsoft MVP (Excel)

 

[Debra Dalgleish]

Select cell B1
Choose Data>Validation
From the Allow dropdown, choose List
In the Source box, type:

=OFFSET($D1,0,0,1,COUNTA($D1:$G1)-COUNTBLANK($D1:$G1))

Copy cell B1 down to the last row of data

Hello, I have a list with values,
I want to create validation list for each cell depending on value in cel
[A]
[A] [D] [E] [F]
[G]
[1] DI16 select from [D1]:[F1] DIa DIb DIc
[2] DO16 select from [D2]:[F2] DOa DOb DOc
[3] DI4 select from [D3]:[E3] DIa DIb
[4] AI1 select from [D4]:[G4] AIa AIb AIc AId

The values in [D] through [G] are calculated

Can some one help me with this, Cause I'm getting stuck

THanks a lot in advance