I wish to automatically populate cells with list data when a item.

J

juggernaught

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

RagDyer

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!
==============================================


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

Michael

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
 
Top