41,985 views
How to create a linked drop-down list in Excel based on another list, so that the drop-down lists are dependent on each other in the data, so that if the basic list classification is chosen, the dependent list is immediately filtered to show the classifications related to the basic classification. To download the file for practical application: https://www.mediafire.com/file/ox4loh... Explanation of the Indirect() function: • Explanation of the INDIRECT function in Excel INDIREC...