It will change the meaning, though there could be overlap.
"in" - characteristics that the partner will have.
"from" - things the partner will give to them.
What I'm looking for in a partner is someone who understands me.
What I'm looking for from a partner is understanding.