validation list of two valies

[faizee]

Dear All
following is my data
[TABLE="width: 313"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]CODE[/TD]
[TD]MATERIAL 1[/TD]
[TD]MATERIAL 2[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]150 X 215[/TD]
[TD]400X00[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]150 X 215[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]124[/TD]
[TD] [/TD]
[TD]500 C 1[/TD]
[/TR]
[TR]
[TD]112[/TD]
[TD]150 X 215[/TD]
[TD]24.5[/TD]
[/TR]
</tbody>[/TABLE]


MY QUERY IS
When I enter Code in one cell., then the other cell validation list only contain material 1 and material 2 values
for example: for Code 112, validation list should be 150 x 215 & 24.5
thanks

 

[faizee]

is anyone here, who could help me in this query

i will thankful