Can someone suggest a formula for the following? I have a worksheet where I need to have a drop down list of properties, based on what is chosen for the property in the next column I need a drop down list that chooses only the buildings associated with that property. In the next column I would yet again need a drop down list of the units associated with that building at that property. Can anyone suggest anything? I am using numbers as well as text.
