Using Defined Names with Data Validation Depend and Data Validation Multi Select

[Vinnie Chan]

Hi,

I want to use Data Validation in a form. I have already defined names with the columns I want to show in the Class dropdown (E9) when Category dropdown (E8) is selected. E9 also needed to be a Multi Select dropdown.

I tried to use INDIRECT and IF...LOOKUP in Data Validation, but returned with error.

Please help me to solve this problem. The file I'm attaching is a lot smaller than the actual one. Would that be too big to use Data Validation?

Thanks for the help.

Vinnie