Can alcohol evaporation get you drunk?
Can you get drunk off alcohol vapor? Absolutely. Apparently in the early 2000s, a alcohol vapor device was invented and subsequently banned in some American states, see Wikipedia here.

However, if you cook with alcohol, e.g. deglazing a pan with some wine, sherry, etc., the amounts are not that high, and I doubt you stand above the pan and completely inhale every part of the alcohol vapor. Still, if you want to avoid getting tipsy, just let the alcohol evaporate, maybe set your range hood (correct word?) to a higher setting so it draws away the vapor quickly.