| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent selection of cells, based on value of another? | Excel Worksheet Functions | |||
| How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
| locking cells based on results at runtime | Excel Worksheet Functions | |||
| populate a limited # of cells with a set value | Excel Worksheet Functions | |||
| I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) | |||
Threaded Mode
