Sweetened condensed milk has been cooked down and has sugar added to it. I use it in things like Magic Cookie Bars.
Evaporated milk has been taken down to very little or no water in the milk and when you use it in baking, etc, you can add water. I use it 2/3 milk to 1/3 water for my baking and straight up in sauces like Chicken ala king.