Add formula for dynamic drop-down list to Data Validation

%3CLINGO-SUB%20id%3D%22lingo-sub-2051997%22%20slang%3D%22en-US%22%3EAdd%20formula%20for%20dynamic%20drop-down%20list%20to%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2051997%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22750%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22750%22%3EDependent%20drop-down%20list%20is%20not%20working.%20The%20formula%20works%20when%20F9%20is%20pressed%20in%20the%20cell%20but%20does%20not%20work%20when%20I%20drag%20it%20down%20to%20cells%20below%20it.%20I%20can%20not%20cut%20and%20paste%20it%20into%20data%20validation%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2051997%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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
0 Replies