software

I'm working on creating a form in Excel that needs to contain different
information in the body of the form based on the selection from a drop down
list. for example: if i choose quot;C2quot; from the drop down list then I want cell
A5 to fill with quot;The car sped by at 55 mph.quot; and cell B5 with quot;puppies sure
are cute.quot; and cell A6 with quot;crack is whack.quot; and cell B6 with quot;I'm so hungry
I could eat a horse.quot; All of this fill-in information would be on another
worksheet.

Thanks for any help.
Sheldon

I would recommend creating a VLOOKUP table with all your options, and then
using various VLOOKUP formulas to find the selections you want for each
cell....such as

=VLOOKUP(a1,YourLookupTable,4,FALSE)

hth
Vaya con Dios,
Chuck, CABGx3
quot;Sheldonquot; wrote:

gt; I'm working on creating a form in Excel that needs to contain different
gt; information in the body of the form based on the selection from a drop down
gt; list. for example: if i choose quot;C2quot; from the drop down list then I want cell
gt; A5 to fill with quot;The car sped by at 55 mph.quot; and cell B5 with quot;puppies sure
gt; are cute.quot; and cell A6 with quot;crack is whack.quot; and cell B6 with quot;I'm so hungry
gt; I could eat a horse.quot; All of this fill-in information would be on another
gt; worksheet.
gt;
gt; Thanks for any help.
gt; Sheldon


If all the various cells respond the same way every time to each
selection, that is, if quot;B5quot; always says quot;puppies are cutequot; whenever
quot;C2quot; is selected, then yes this can be done with nested IF stmts, or
Vlookup, etc. in each of the response cells. The dropdown box has a
cell link in its control that changes value based on the selection. For
instance, if quot;C2quot; is your first selection in the dropdown, the link cell
value will be quot;1quot;. If you choose the second selection, let's say it is
quot;D3quot;, then the link cell value will be quot;2quot;, etc.

That link cell value can be used to determine the value you enter into
the various response cells - as I said by a Vlookup, IF stmts, etc.

I hope that helps.--
Conor
------------------------------------------------------------------------
Conor's Profile: www.excelforum.com/member.php...oamp;userid=30450
View this thread: www.excelforum.com/showthread...hreadid=501097Thanks. This is very helpful. I think I'll go the IF stmt route. Have a great
weekend.

quot;Conorquot; wrote:

gt;
gt; If all the various cells respond the same way every time to each
gt; selection, that is, if quot;B5quot; always says quot;puppies are cutequot; whenever
gt; quot;C2quot; is selected, then yes this can be done with nested IF stmts, or
gt; Vlookup, etc. in each of the response cells. The dropdown box has a
gt; cell link in its control that changes value based on the selection. For
gt; instance, if quot;C2quot; is your first selection in the dropdown, the link cell
gt; value will be quot;1quot;. If you choose the second selection, let's say it is
gt; quot;D3quot;, then the link cell value will be quot;2quot;, etc.
gt;
gt; That link cell value can be used to determine the value you enter into
gt; the various response cells - as I said by a Vlookup, IF stmts, etc.
gt;
gt; I hope that helps.
gt;
gt;
gt; --
gt; Conor
gt; ------------------------------------------------------------------------
gt; Conor's Profile: www.excelforum.com/member.php...oamp;userid=30450
gt; View this thread: www.excelforum.com/showthread...hreadid=501097
gt;
gt;