Hope i selected the right thread.
Being charged to create a mutli-select data validation list where user selects a Goal from a drop down. once selected, the next drop down would contain ideas on how to achieve that goal.
the selection of data is basically sentences, multi-word.. I know how get the first drop down.. I'm struggling to get the second on to work.
I've attached a brief example. of course there is a big list of each one.
Column A contains the first drop down values (see cell a12) i need B12 to reflect the list of items in C3 thru F5 to appear based on value.
The process can't be too complicated.
I tried =index with match.. but get #N/A guessing because of all the spaces. I'm good with creating some sort of table for each. but not sure how to get Metric to take list and substitute with a different value..
Ie A3 means SM04a then take data in C2 thru c5 and call it SM04a
Hope this makes sense.
Thanks In advance
Steve
Bookmarks