Hi, i would like to know if have a formula or something who can do that.
Example:


A B C D

300 1 300 1
302 2 310 4
305 5 320 9
310 4 330 -
315 8 340 -
320 9 350 -

compare the value of A with C and if was the same, copy the value of B in D. I can do for same lines equals whit "IF" but when are different lines i can't.

Tanks and sorry about my english, but im desperate... i try some sites with examples and nothing works.