Add formula for dynamic drop-down list to Data Validation

[awoolfe]

Hi, 

Dependent drop-down list is not working. The formula works when F9 is pressed in the cell but does not work when I drag it down to cells below it. I can not cut and paste it into data validation