need help

[Bilseka]

if i have a certain cell "cells(x,3)" contains text "steel conduits" or "pvc conduits" and i need another cell to make a validation function on a certain cells(rows),which contain different sizes of steel conduit as example, and this validation changed with change of the value of cells(x,3).

i need the code VB of this case.

Many thanks

 

[CharlesChuckieCharles]

Need a fuller explanation to get an Idea of What you're attempting to do<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Bilseka]

​

i need make validation for the of the copper cables in the cells(c,7) if the value of the cells(b,7) like "Cu Cables"

i need the VB code for this case

 

[Bilseka]

Need a fuller explanation to get an Idea of What you're attempting to do<!--?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /--><o></o>

Dear Charles
if you need more explanation kindly tell me

 

[CharlesChuckieCharles]

what sort of validation.....?

 

[Bilseka]

what sort of validation.....?

validation List

 

[snoopyhr]

see if can get you started....

the F17 and G17 are data validation . G17 is dependent on F17, CAUTION...after selecting your choice.... upon changing of F17, G17 WILL NOT change it needs to be update manually.

Excel Workbook
	A	B	C	D	E	F	G
16	Setup a table similar to this				*	Fst-DD	Dependent DD
17	Material	Cu Cables	PVC Conduits	AL Cable	*	PVC Conduits	PVC Con 3
18	Cu Cables	Cable 1	PVC Con 1	ALCAB1	*	*	*
19	PVC Conduits	Cable 2	PVC Con 2	ALCAB2	*	*	*
20	AL Cable	Cable 3	PVC Con 3	ALCAB3	*	*	*
21	*	*	PVC Con 4	ALCAB4	*	*	*
22	*	*	PVC Con 5	ALCAB5	*	*	*
23	*	*	PVC Con 6	ALCAB6	*	*	*
24	*	*	*	ALCAB7	*	*	*
25	*	*	*	ALCAB8	*	*	*
26	Range names:	*	*	*	*	*	*
27	=AL_Cable	d18:d25	*	*	*	*	*
28	=Cu_Cables	b18:b20	*	*	*	*	*
29	=Material	a18:a20	*	*	*	*	*
30	=PVC_Conduits	c18:c23	*	*	*	*	*
31	*	*	*	*	*	*	*
Sheet9

#VALUE!

 

[Bilseka]

Dear snoopyhr
thanks for your help
but this error message stop the equation

 

[snoopyhr]

Sorry you needed to make the address to the range names absolute.

change the formula in the source box to :

=CHOOSE(MATCH(F17,$B$17:$D$17,0),INDIRECT(SUBSTITUTE($B$17," ","_")),INDIRECT(SUBSTITUTE($C$17," ","_")),INDIRECT(SUBSTITUTE($D$17," ","_")))

 

[Bilseka]

Sorry you needed to make the address to the range names absolute.

i don't understand what mean with name absolute

many thanks for your help