M
MarcoZ
Creating a xl to collect requirements. All cells in col k contain the same
static dropdown. I want column m to contain dynamic dropsdowns - dropdowns
that are based on the content of the cell in column k.
I have assigned each static dropdown option in col k setting the adjacent
cell in col l to a numeric value (e.g., 100, 200, 300, etc.) via vlookup. I
have assigned a number (e.g., 1,, 2, 3,....31, 32, etc.) to each row in the
array where the dynamic dropdown options will be loaded. That simplifies the
vlookup for col m. Elsewhere I have assigned each static option + eligible
dynamic dropdown pair a unique value (e.g., cells w2 through w6="creation of
a task", x2="Action data is updated, y2=201; x3="Notification is sent to a
user", y3=202; etc.) These represent valid combinations of causes and effects.
I have set it up so that when the user selects an option from col k, col l
(hidden) will have the numeric value (e.g., 200). This value is to be added
to row ref (e.g., 1, 2, 3, etc.) in the dynamic array to create the dymanic
vlookup array for col m.
My problem is getting the value in cells (when the user makes a selection)
in col l "copied" to the same cell referenced to be referenced by dynamic
lookup array.
Thanks!
static dropdown. I want column m to contain dynamic dropsdowns - dropdowns
that are based on the content of the cell in column k.
I have assigned each static dropdown option in col k setting the adjacent
cell in col l to a numeric value (e.g., 100, 200, 300, etc.) via vlookup. I
have assigned a number (e.g., 1,, 2, 3,....31, 32, etc.) to each row in the
array where the dynamic dropdown options will be loaded. That simplifies the
vlookup for col m. Elsewhere I have assigned each static option + eligible
dynamic dropdown pair a unique value (e.g., cells w2 through w6="creation of
a task", x2="Action data is updated, y2=201; x3="Notification is sent to a
user", y3=202; etc.) These represent valid combinations of causes and effects.
I have set it up so that when the user selects an option from col k, col l
(hidden) will have the numeric value (e.g., 200). This value is to be added
to row ref (e.g., 1, 2, 3, etc.) in the dynamic array to create the dymanic
vlookup array for col m.
My problem is getting the value in cells (when the user makes a selection)
in col l "copied" to the same cell referenced to be referenced by dynamic
lookup array.
Thanks!