Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 13th 06, 03:30 PM posted to microsoft.public.excel.misc
Sheldon
 
Posts: n/a
Default Auto populate several cells based on a selection from drop down li

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 "C2" from the drop down list then I want cell
A5 to fill with "The car sped by at 55 mph." and cell B5 with "puppies sure
are cute." and cell A6 with "crack is whack." and cell B6 with "I'm so hungry
I could eat a horse." All of this fill-in information would be on another
worksheet.

Thanks for any help.
Sheldon

  #2   Report Post  
Old January 13th 06, 03:55 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Auto populate several cells based on a selection from drop down li

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



"Sheldon" wrote:

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 "C2" from the drop down list then I want cell
A5 to fill with "The car sped by at 55 mph." and cell B5 with "puppies sure
are cute." and cell A6 with "crack is whack." and cell B6 with "I'm so hungry
I could eat a horse." All of this fill-in information would be on another
worksheet.

Thanks for any help.
Sheldon

  #3   Report Post  
Old January 13th 06, 04:03 PM posted to microsoft.public.excel.misc
Conor
 
Posts: n/a
Default Auto populate several cells based on a selection from drop down li


If all the various cells respond the same way every time to each
selection, that is, if "B5" always says "puppies are cute" whenever
"C2" 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 "C2" is your first selection in the dropdown, the link cell
value will be "1". If you choose the second selection, let's say it is
"D3", then the link cell value will be "2", 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: http://www.excelforum.com/member.php...o&userid=30450
View this thread: http://www.excelforum.com/showthread...hreadid=501097

  #4   Report Post  
Old January 13th 06, 08:12 PM posted to microsoft.public.excel.misc
Sheldon
 
Posts: n/a
Default Auto populate several cells based on a selection from drop dow

Thanks. This is very helpful. I think I'll go the IF stmt route. Have a great
weekend.

"Conor" wrote:


If all the various cells respond the same way every time to each
selection, that is, if "B5" always says "puppies are cute" whenever
"C2" 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 "C2" is your first selection in the dropdown, the link cell
value will be "1". If you choose the second selection, let's say it is
"D3", then the link cell value will be "2", 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: http://www.excelforum.com/member.php...o&userid=30450
View this thread: http://www.excelforum.com/showthread...hreadid=501097




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent selection of cells, based on value of another? Stilla Excel Worksheet Functions 2 December 7th 05 05:41 PM
How can I populate an Excel cell based on the data in another cell JerseyBoy Excel Worksheet Functions 3 September 30th 05 03:53 PM
locking cells based on results at runtime aken Excel Worksheet Functions 3 June 22nd 05 02:01 PM
populate a limited # of cells with a set value Jane Excel Worksheet Functions 5 March 18th 05 09:43 PM
I wish to automatically populate cells with list data when a item. juggernaught Excel Discussion (Misc queries) 2 February 23rd 05 09:49 PM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017