Shape Data Section Changes

[OldSchool1948]

Is there a way to identify when a change is made to a Shape Data section "Prop." row?  I have two rows Prop.VMSeries and Prop.VMSubSeries that contain drop-down lists.  I want to filter the information shown in the Prop.VMSubSeries Format cell based on the value shown in the Prop.VMSeries Format cell.   For example:

VMSeries values:
D-Series
H-Series

D-Series VMSubSeries values:
Standard_D1
Standard_D2
etc.

H-Series VMSubSeries values:
Standard_H1
Standard_H2
etc.

Currently, I have all possible values in the VMSubSeries drop-down.  A more elegant context-sensitive solution would be great 

[metuemre]

Please use the formula in the red rectangle on attached picture. Different solutions can be applied for this kind of cases.

[OldSchool1948]

The LOOKUP function looks promising.  I will definitely give this a try.  Thanks much.

[vojo]

Look at dependson to trigger off changes

[OldSchool1948]

Thanks.  I'll tinker with that as well.