Hi All,
I am new to this forum and hoping to get some help. I know this has been asked before however I am looking to do something without having to use VBA or macros.
I currently have 2 columns (Column D and Column E), column D contains a data validation list of Cities and column E is a dependent data validation list that then provides a list of buildings (that my company has offices in) depending on what city is selected. I understand that in order to reset column E if column D is changed I need a VBA code, but im wondering if there is a way to create an error message instead that looks up from a table whether what is in column E matches what is in column D i.e. if city chosen is Sydney (column D) then Column E can only be Building A, Building B or Building C, if city chosen is Melbourne then Column E can only be Building D, Building E or Building F.
Does that make sense? And is that possible? Or is VBA my only option?
Thanks so much in advance!
I am new to this forum and hoping to get some help. I know this has been asked before however I am looking to do something without having to use VBA or macros.
I currently have 2 columns (Column D and Column E), column D contains a data validation list of Cities and column E is a dependent data validation list that then provides a list of buildings (that my company has offices in) depending on what city is selected. I understand that in order to reset column E if column D is changed I need a VBA code, but im wondering if there is a way to create an error message instead that looks up from a table whether what is in column E matches what is in column D i.e. if city chosen is Sydney (column D) then Column E can only be Building A, Building B or Building C, if city chosen is Melbourne then Column E can only be Building D, Building E or Building F.
Does that make sense? And is that possible? Or is VBA my only option?
Thanks so much in advance!