Conditional Paragraphs
 

OK. Thanks to the support received here I got Conditional Dropdowsn working
nicely.

Now I need to fill a cell with a paragraph of text depending on a dropdown
list selected elsewhere

e.g. If I select Apples from a dropdown list of fruit, in another cell I get
a paragraph telling me about apples.

Thanks

Mike

Conditional Paragraphs
 

Mon, 21 May 2007 14:33:18 +0800 from Mike Lang
:
OK. Thanks to the support received here I got Conditional Dropdowsn working
nicely.

Now I need to fill a cell with a paragraph of text depending on a dropdown
list selected elsewhere

e.g. If I select Apples from a dropdown list of fruit, in another cell I get
a paragraph telling me about apples.

=if(A27="apples", "apple text", "orange text")

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Conditional Paragraphs
 

Another option that might permit more text in the descriptive paragraph:

On a separate sheet (which you can hide) create a table with the list items
in one column and the paragraphs in the next column. Lets say you have 10
items in the list, and your table goes in a sheet named SourceInfo from A1 to
B10, then in the descriptive paragraph cell on the sheet with the dropdown
(dropdown in G1 to keep things clear here)
=VLookup(G1,SourceInfo!$A$1:$B$10,2,0)

Extra hint: On that hidden sheet, choose the list of items (left column only
with the fruit names in it) and in the Name Box (left of the formula bar,
just above the "A" column identifier) type in a name for that list such as
FruitList and press the [Enter] key. Now the list can be referred to by the
name you entered. For your dropdown, use Data Validation and choose List for
the "allow" and then for the source of the list type in =FruitList.


"Mike Lang" wrote:

OK. Thanks to the support received here I got Conditional Dropdowsn working
nicely.

Now I need to fill a cell with a paragraph of text depending on a dropdown
list selected elsewhere

e.g. If I select Apples from a dropdown list of fruit, in another cell I get
a paragraph telling me about apples.

Thanks

Mike

Conditional Paragraphs
 

Thanks very much

"Mike Lang" wrote in message
...
OK. Thanks to the support received here I got Conditional Dropdowsn
working nicely.

Now I need to fill a cell with a paragraph of text depending on a dropdown
list selected elsewhere

e.g. If I select Apples from a dropdown list of fruit, in another cell I
get a paragraph telling me about apples.

Thanks

Mike