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/