View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default 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