Hello all,
I’m trying to figure it out for weeks to solve this problem.
Base A : I want to get address data (zip code) + buying rate from this base
Base B : I want to get address data (zip code) + selling rate from this base
Base C: When I write that specific address/zip code and it matches with the address in Base A and Base B, I want to see buying rate and selling rate in separate columns automatically.
So it is like;
zip code base A + zip code base B = buying rate base A + selling rate base B in base C
That would be great if you could help me to solve this issue because I’m about to lose my mind :slightly_smiling_face: What is the right way to do it? Is it by a formula? Is it by something else? Please help me.
Thank you.