Conditional Paragraphs

  • Thread starter Thread starter Mike Lang
  • Start date Start date
M

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.

Thanks

Mike
 
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.
Click to expand...

=if(A27="apples", "apple text", "orange text")
 
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.
 
Back
Top