Forum Discussion
Problem with Data Validation Dependant Dropdown
vitoaiaco Aha! I missed that you also had a reference to C1 in the beginning of the formula. change that also to E1 and it will work.
Ignore what I said about an easier way. It's more a different way as I don't particularly like the use of OFFSET. Reduced your file to only 4 rows of raw data to test it. See attached.
Thank you Riny...
Even when changing the range as you mentioned, I'm still getting only 1 option in the dropdown list when selecting LDV or BUS.
If there's an easier way, I would appreciate your advise... I'm on Office 365
vitoaiaco Aha! I missed that you also had a reference to C1 in the beginning of the formula. change that also to E1 and it will work.
Ignore what I said about an easier way. It's more a different way as I don't particularly like the use of OFFSET. Reduced your file to only 4 rows of raw data to test it. See attached.
- Thank you very much!!!
Problem solved