Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If certain item is picked, then text added...
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If certain item is picked, then text added...
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If certain item is picked, then text added...
Create a table with your items from D in one column (I presume you already have these as a list somewhere on the spreadsheet) and your corresponding text in column to the right then you can just do a VLOOKUP in column N =VLOOKUP(D1,table,2,0) you can either use INSERT NAME DEFINE to define your table name and use in the formula or use the actual cell refs, e.g. =VLOOKUP(D1,Y1:Z20,2,0) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511525 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If certain item is picked, then text added...
Thanx guys, I'll try it -- 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If certain item is picked, then text added...
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 -- 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If certain item is picked, then text added...
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) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511525 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort bar chart in excel | Charts and Charting in Excel | |||
Wrap Text | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |