Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I wish to automatically populate cells with list data when a item.
I wish to automatically populate cells with static data when a selection is
made from a drop down list. Say when 3000 is selected from the drop down list, I want the description associated with 3000 to be automattically populated in the cell next to it. I'm sure this is easy but....... |
#2
|
|||
|
|||
You can use the Vlookup() function to fill in the adjoining cells, where it
(Vlookup) will match the drop-down list selection by polling an existing datalist, which can be located in an "out-of-the-way" section of the current sheet, or on a different sheet altogether. Check out this web page of Debra Dalgleish for instructions. http://www.contextures.com/xlFunctions02.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "juggernaught" wrote in message ... I wish to automatically populate cells with static data when a selection is made from a drop down list. Say when 3000 is selected from the drop down list, I want the description associated with 3000 to be automattically populated in the cell next to it. I'm sure this is easy but....... |
#3
|
|||
|
|||
Hi
Have a look at the VLOOKUP function to solve this issue. If your drop down data is in A1, you could use the VLLOKUP in B1 as follows. =VLOOKUP(A1,range,2, FALSE) where A1 is your reference data, range is the cells where your lookup data is stored, 2 is the column that holds your description and FALSE forces the formula to only give a result if there is an exact match. HTH Michael "juggernaught" wrote: I wish to automatically populate cells with static data when a selection is made from a drop down list. Say when 3000 is selected from the drop down list, I want the description associated with 3000 to be automattically populated in the cell next to it. I'm sure this is easy but....... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup with two variable data list cells | Excel Worksheet Functions | |||
Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |