nathanlogan
New Member
- Joined
- Apr 29, 2021
- Messages
- 1
- Office Version
- 365
Hi,
I have an excel with 4 columns with Dropdowns.
Column A : Country
Column B : State
Column C : City
Column D : Postal Code
If a user selects a duplicate combination then I want to show an error message and clear the value in the dropdown which triggered the validation event.
Example :
In Row 3: If I select "State" => "Alabama" from dropdown list, it should throw an error message and clear the selected value in the dropdown.
Similarly for Row 4 with "PostalCode" and in Row 5 with "City" column.
Thanks in advance.
I have an excel with 4 columns with Dropdowns.
Column A : Country
Column B : State
Column C : City
Column D : Postal Code
If a user selects a duplicate combination then I want to show an error message and clear the value in the dropdown which triggered the validation event.
Example :
In Row 3: If I select "State" => "Alabama" from dropdown list, it should throw an error message and clear the selected value in the dropdown.
Similarly for Row 4 with "PostalCode" and in Row 5 with "City" column.
Thanks in advance.