Dependant List
 

Not to familiar with excel lists but is it possable to create a list and when
an item is selected two other cells would be automatically filled in?

A B C

BLUE MEXICO 737500

Above example if end user selects the name blue from a drop down list then
column B and C will be populated to country and account associated with the
name. Is his done through a macro?

Dependant List
 

On 21 Jun., 05:51, acss wrote:
Not to familiar with excel lists but is it possable to create a list and when
an item is selected two other cells would be automatically filled in?

*A * * * * * B * * * * * * C

BLUE * *MEXICO *737500

Above example if end user selects the name blue from a drop down list then
column B and C will be populated to country and account associated with the
name. Is his done through a macro?

Hi

Look at the "VLookup" function, it should do what you need.

Regards,
Per

Dependant List
 

check debra's site

http://www.contextures.on.ca/xlDataVal02.html

--


Gary


"acss" wrote in message
...
Not to familiar with excel lists but is it possable to create a list and when
an item is selected two other cells would be automatically filled in?

A B C

BLUE MEXICO 737500

Above example if end user selects the name blue from a drop down list then
column B and C will be populated to country and account associated with the
name. Is his done through a macro?