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.......

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.......

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.......