Thread: Dependant List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default 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