validation list

[Forestq]

hi,

in Sheet2 I have list:

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]columnA (name)[/TD]
[TD]ColumnaB (region)[/TD]
[/TR]
[TR]
[TD]Audi[/TD]
[TD]Euro[/TD]
[/TR]
[TR]
[TD]Ford[/TD]
[TD]USA[/TD]
[/TR]
[TR]
[TD]Chevi[/TD]
[TD]USA[/TD]
[/TR]
[TR]
[TD]VW[/TD]
[TD]EURO[/TD]
[/TR]
[TR]
[TD]Porshe[/TD]
[TD]EURO[/TD]
[/TR]
</tbody>[/TABLE]


I used manager name to define range:
Cust_Name = Sheet2!$A:$A
Reg_Name = Sheet2!$B:$B

Now, in Sheet1 I did data validation and I have:
A2 = list of name (from Sheet2, columnA)
B2 = list of region (from Sheet2, columnB)

How to do, like if I in A2 I will choose Audi or Porshe then automatically in B2 will show Euro?

 

[L. Howard]

Take a look here.

A Dynamic Dependent Drop Down List in Excel | Excel Semi-Pro

Regards,
Howard