Conditional Drop Down List

[Muhammad Wasif]

Hi,
I need help in defining a conditional list.
On one sheet I have the following table:
Type MSISDN
Pilot 97313100427
DID 97313100431
DID 97313100428
Extension 97301001685
Extension 97301001686
Extension 97301001687
Extension 97301001688
Extension 97301001689
Extension 97301001690
Extension 97301001691
Extension 97301001692
Extension 97301001693
Extension 97301001694

On another sheet I have columns for "Extension" and "DID". I need to select numbers of each category and show them as drop down list under that column.

Regards,

 

[bosco_yip]

See as per attached example file

Regards
Bosco