If certain item is picked, then text added...

R

roger_home

I've got about 20 items in a pull down in Column D. Based on which item
is picked, I need certain text to go in N, for instance:

If "SURVEY" is picked in D, I need "pr1 pr2 cut fold sort put away" put
in N.

There are 7 (right now) alternate strings of text for N, based on which
of the 20 is picked in D.

Any help would be appreciated...be aware, I am a newbie/intermediate in
EXCEL.

Thanx
 
D

daddylonglegs

Create a table with your items from D in one column (I presume yo
already have these as a list somewhere on the spreadsheet) and you
corresponding text in column to the right then you can just do
VLOOKUP in column N

=VLOOKUP(D1,table,2,0)

you can either use INSERT > NAME > DEFINE to define your table name an
use in the formula or use the actual cell refs, e.g.

=VLOOKUP(D1,Y1:Z20,2,0
 
P

Pete_UK

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
 
R

roger_home

I can't get it to work...my items are a list called "item1" on sheet
2,A1:A20
What I want to go in Column N is a list called "actions" on sheet 2,
B1:B22
 
D

daddylonglegs

Hi roger, those ranges are different sizes, I assume actions is B1:B20

try in N1

=VLOOKUP(D1,sheet2!$A$1:$B$20,2,0)
 
Top