Listing datas using macros

Friends,

I have a list of currencies in column A and in column B i have the respective currencies and their calender name. This details are in worksheet2.

Ex: Currencies Calender name
AED UAE
USD STOCK

In worksheet1 i have two columns where i have named column A as Currencies and Col B as Calender.

I need a macro coding in worksheet1, where if i type any currency in col A for ex: USD then the calender name assigned to that particular currency in worksheet2(STOCK) should get populated automatically in colB in worksheet1.

Some currencie has more than one calender names. Hence in such cases if i type the currency name in col A then in col B the calender names list sholud appear.

Kindly help me by providing this macro coding for it...Thanks a ton in advance.