If certain item is picked, then text added...
Your pull down on column D presumably refers to a list of 20 items
somewhere - assume this is in X1 to X20. Next to these in Y1 to Y20 you
should add the text which you want to associate with each of your
pull-down values, so if "SURVEY" is in X5, for example, you would put
"pr1 pr2 cut fold sort put away" in Y5. Then in N1 you would put the
formula:
=VLOOKUP(D1,$X$1:$Y$20,2,0),
assuming your pull-down is in D1.
Hope this helps.
Pete
|