1. In my Excel sheet, I am using a drop-down menu in cell U3 to fetch the result in V,W,and Y
2. The data for columns V, W, and Y is fetched using Index matching from other columns (source). The complete data is comprised of 760 rows.
3. I want to insert a drop-down menu on column X using data validation. This means that data for column X won't be fetched using Index matching and the user can choose the value from the drop-down list.
Problem:
1. U3 = Yeong Ho, I choose a value in X3 (using drop-down). Let's say this value is AA
2. When U3 = Mich, the value in X3 remains intact = AA and the cell does not become blank to choose a new value for X3 which is BB
3. This is happening on Column X of all rows based on the result being fetched using Index matching.
Required:
I want the values in column X to be associated with the value in U3 and that whenever I change the value of U3, column X becomes blank and then I can choose the value in column X using the drop-down. Once the value in column X is chosen, it gets associated with that particular selection of U3 and the cycle goes on every time when I choose another value in U3.
2. The data for columns V, W, and Y is fetched using Index matching from other columns (source). The complete data is comprised of 760 rows.
3. I want to insert a drop-down menu on column X using data validation. This means that data for column X won't be fetched using Index matching and the user can choose the value from the drop-down list.
Problem:
1. U3 = Yeong Ho, I choose a value in X3 (using drop-down). Let's say this value is AA
2. When U3 = Mich, the value in X3 remains intact = AA and the cell does not become blank to choose a new value for X3 which is BB
3. This is happening on Column X of all rows based on the result being fetched using Index matching.
Required:
I want the values in column X to be associated with the value in U3 and that whenever I change the value of U3, column X becomes blank and then I can choose the value in column X using the drop-down. Once the value in column X is chosen, it gets associated with that particular selection of U3 and the cycle goes on every time when I choose another value in U3.
