Hi all,

Im new here. I've been trying to do the dependent drop down list but always return an error - "The source currently evaluates to an error data validation..."

I have two drop down list in cell A2 and B2. B2 is dependent to A2. I manaDrop Down.xlsxged to do the drop down for A2 but B2 returned the above error. I've tried to use vlookup but still cant.

Attached is the file for your reference. Hope anyone can help me. Thanks!Attachment 416633