I have two dropdown lists. The first one (D2) lists all the Watersheds in my area. The second one (D4) I need to list all the Sites located within that watershed. See table below. It is preferred that the Sites list only have the site number; i.e. "Site 1, Site 2, etc." I have several Index:Match combinations within Data Validation without any luck. Any help is appreciated.
|2||Alamo Arroyo Watershed||Alamo Arroyo WS NRCS Site 1||Watershed:||Aquilla-Hackberry Creek Watershed|