No, it was actually very counter-productive in that it created many serious problems while solving none. Prohibition was an attempt to legislate morality and ended up causing people to turn to distilled alcohol so that the most alcohol could be transported with minimum risk. Also, prohibition strengthed organized crime since that was the only way alcohol was distributed. It led to widespread corruption of public officials, the loss of tax revenue to government, disrespect for law, the promotion of binge drinking (people drank a lot when they had the chance) and discouraged moderate drinking, led to the consumption of illegal and often tainted alcohol that caused such problems as death, glorified gangsters, and created many more problems.
It also encouraged a culture of gangsterism