Hello
I need a formula, which checks a range of cells, and if the value is equal to another cell, copies another cell value to this cell. For e.g.
I have a column(A) with a, b, c, d, in sheet1 and another column(A) in sheet2 with c, d, b, a. I want to copy values of C column of sheet1 to C column of sheet2, where the value of Column A in both sheets is a, doesn't matter which row.
thanks