Does being sterile mean that you cant get it up?

No, that's being impotent. Sterile means not being able to reproduce; that is, a sterile man cannot father a child.