Probably a vlookup, Roger, particularly if you want to be able to easily add
to the list.
See:
http://www.officearticles.com/excel/...soft_excel.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"roger_home" wrote
in message ...

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


--
roger_home
------------------------------------------------------------------------
roger_home's Profile:
http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=511525