Drop down lists

Hi Paul

I have created a drop down list.

I want to create a merge a drop down list with an IF statement.

For eg:

If the left colum contains a yes then this colum is o otherwise choose from the drop down list.

Colmn A Colm B

Yes =if(A1="Y", then pick from drop down list otherwise 0.)

Can that be done in excel?

Thanks

Gurdeep