Load a drop down list based on selection of another list in a cell
Use the combination of data validation, Excel range names and the INDIRECT function to load a list of sub categories of goods based on the selection of a list in another cell. #protips #trending #shorts