Has anyone received a job offer from a job they were somewhat unqualified for and if so what happed?

Maybe you had some of the qualifications or most. Some job ads ask if your familiar with certain softwares and there will be that one or two that you don't have that much experience with. Or maybe you just had the capabilty to learn, did that job offer you a position or completely rejected you?

Is it worth applying if they want you to possess a security clearance or certification and you don't have one? Did they sponsor you to receive a sercurity clearance?

In my case I would qualify for a clearance if they sponsored me.

Please explain your experience.