Unique Data Validation List with indirect function

[Kamran01]

Dear Excel Experts,

I have some details like this,

Customer . . . Style Name
Max . . . . . . FB06
Max . . . . . . 701XT
OVS . . . . . . MARK
Strd . . . . . . TRO002

I want data validation list of unique customer and in other column i want indirect function of customer which is style name. Can any buddy help me.

Thanks
Kamran Noor

 

[Kamran01]

Bump

 

[Kamran01]

Bump again