Based on the value selected, for example, 'W', I want to populate another dropdown list with the variable 'W_Lst' that creates a dropdown list of all the W Sections. If 'C' is selected, the dropdown list will use the variable 'C_Lst' for all the C Sections.
I want to select a particular W Section from the dropdown list and using the Vlookup function to select the properties from another array called 'W_Tbl' which has all the properties for all the W Sectins. If 'C' is selected the array is called 'C_Tbl' and these properties are accessed.
Alternately, is it possible to create another variable equal to, say, Temp_Tbl and set this equal to either C_Tbl or W_Tbl and use the Temp_Tbl value in the VLookup function.
Clear as mud... Is it possible to do this in Excel?