I have one column where i have values called domain and another column which has values called role.

there can be multiple roles for a domain e.g.

```
Domain Role
A       XYZ
A       ABC
B       DEF
C       DHG
A       LKJ
B       OIO
C       CND

```

etc.

I have in same sheet or a different sheet a column containing unique values in column Domain and in the next column i have to display a dropdown based on selection in the Domain column.
example if someone selected B in the domain dropdown in one row, then the role column of the same row should display in the drop down only values which are specific to B values in the roles shown above i.e. DEF & OIO