How do I accomplish this? I keep getting errors.

I have a drop down of Not Started, In Work, Completed in C4
and in C3 I want a percentage to match 0%, 50%, 100% respectfully.

And I want this to work for the whole columns.

Thanks!