Conscious love is discovered between two souls within the spheres of thought (Netzach), feeling (Hod), will (Tiphereth), chemistry (Yesod-Malkuth) consciousness (Geburah) and spirit (Chesed).
Love and sexual attraction are not exclusive. Sexual attraction or chemistry is necessary, but it is not the exclusive factor of marital longevity.
Many people get into relationships based on sexual attraction (Yesod) and emotional affinity (Hod), but in their thoughts (Netzach) they don't relate at all. One partner is Catholic and the other Muslim, etc.
Or, two individuals can be attracted within the body, heart, and mind, but not will (Tiphereth). Such relationships clash horribly and produce a lot of suffering.
Regarding Yesod: yes, sexual attraction is the crux, focus, and crucible in which the other psychological and spiritual dynamics of a relationship coagulate, meet, and transform. "Platonic" relationships without sexual attraction are true failures, because there is no fire to work with.
As to whether or not you will meet the person of your dreams, you have to awaken from your dreams first. Learn to astral travel and communicate with your Being. That is how you will know for certain who your real partner is.
A perfect matrimony is developed upon the basis of sexual, emotional, mental, and volitional affinity, within the spheres of thought, feeling, and will. It initiates as a spark and develops into a bonfire through the work. No one starts with perfection: it is worked for and earned.
The sexual yearning for one's perfect compliment is not lust. However, since we are 97% ego, we project our corrupted desires into the world when seeking an ideal partner. This is the problem.
You have to slay that ideal in your mind in order to appreciate the beauty of your real partner, whom will arrive when divinity needs it, not because you want it.
For thirty years I sought God. But when I looked carefully I found that in reality God was the seeker and I the sought. -Bayazid al-Bastami