| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto populate cell based on previous cell drop down list selectio.
I am trying to auto populate data in a cell based on the selection in the
previous column. I have created two lists - one with the name and one with a number that is associated with that name. In my data entry fields, I would like to be able to select the name from the "name list" (I have done this already), but then I would like the number data entry field to auto populate to the number associated with the name in the lists that I have created. Any help would be greatly appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto populate cell based on previous cell drop down list selectio.
Use a VLOOKUP / HLOOKUP formula that takes the value given by the dropdown
list and uses it to lookup for the other value.... "PuzzledbyLists" wrote: I am trying to auto populate data in a cell based on the selection in the previous column. I have created two lists - one with the name and one with a number that is associated with that name. In my data entry fields, I would like to be able to select the name from the "name list" (I have done this already), but then I would like the number data entry field to auto populate to the number associated with the name in the lists that I have created. Any help would be greatly appreciated |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto populate cell based on previous cell drop down list selectio.
There are instructions here for VLookup:
http://www.contextures.com/xlFunctions02.html And a sample order form that uses VLookup formulas to complete customer information: http://www.contextures.com/xlOrderForm01.html PuzzledbyLists wrote: I am trying to auto populate data in a cell based on the selection in the previous column. I have created two lists - one with the name and one with a number that is associated with that name. In my data entry fields, I would like to be able to select the name from the "name list" (I have done this already), but then I would like the number data entry field to auto populate to the number associated with the name in the lists that I have created. Any help would be greatly appreciated -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a price based on a customer from a drop down list | Excel Discussion (Misc queries) | |||
| How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
| Code to an in cell drop down list | Excel Discussion (Misc queries) | |||
| Drop list affected by previous choice | Excel Worksheet Functions | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Hybrid Mode
