Hello,
I have created a dropdown menu through data validation. With 4 of the 5 options in the menu, I have made a formula where each of the 4 selections is referencing a different set of data, which will then populate the same range of cells. Here's the code I used:
Here, Cell A9 is where the dropdown menu is located.
However, I am running into a problem when I want to select the other option in the dropdown menu (it is named "Open" in my code). When I select this option, I want to be able to enter in my own data in the same range of cells that are populated when the other 4 options are selected.
Basically, I want this formula to apply to all of the options in the dropdown menu EXCEPT for the "Open" option, in which case I want to enter in my own data. I need these formulas to re-populate the cells if i go from the "Open" option to one of the other options.
Any help would be greatly appreciated!!
I have created a dropdown menu through data validation. With 4 of the 5 options in the menu, I have made a formula where each of the 4 selections is referencing a different set of data, which will then populate the same range of cells. Here's the code I used:
Code:
=IF($A$9="Wellness",Sheet3!B6,IF($A$9="TDS",Sheet3!B16,IF($A$9="Healthy Back Non-Incentive",Sheet3!B25,IF($A$9="Healthy Back Incentive",Sheet3!B34,IF($A$9="Open",HELP,"")))))Here, Cell A9 is where the dropdown menu is located.
However, I am running into a problem when I want to select the other option in the dropdown menu (it is named "Open" in my code). When I select this option, I want to be able to enter in my own data in the same range of cells that are populated when the other 4 options are selected.
Basically, I want this formula to apply to all of the options in the dropdown menu EXCEPT for the "Open" option, in which case I want to enter in my own data. I need these formulas to re-populate the cells if i go from the "Open" option to one of the other options.
Any help would be greatly appreciated!!
