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?

On 21 Jun., 05:51, acss <joekr...@hotmail.com> 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

check debra's site

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

--


Gary


"acss" <(E-Mail Removed)> wrote in message
news:1EB6090F-340E-47DA-B3AA-(E-Mail Removed)...
> 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?