Excel: Adding Table as a Data validation using INDIRECT function

1. Create a table and name it. Say TableDiv and the items should be of the column name Division
2. In the data validation source, select the INDIRECT function and add the following validation =indirect("TableDiv[Division]")