Returning a specific value when item is selected from a drop-down list
I have created drop-down lists (course titles) from data tables listed on other worksheets. When a particular course is selected from a drop-down list, I want Excel to automatically populate the related value (course hours) from the same data tables.
|