How to syncronize data in two different sheets
I have a sheet with two columns and some data, and another sheet with a column and the same data of the first column in the first sheet, but in a different position. So, i need to insert in the column 2 of the second sheet the correct data.
How can i do it?
Example:
_Sheet 1:
Column1 Column2
A 1
B 2
C 3
_Sheet 2:
Column1 Column2
if B --> 2
if C --> 3
if A --> 1
Thanks
Diego
|