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

something like this:

=VLOOKUP(A1,Sheet1!$A$1:$B$3,2,0)

change A1 to the location of the first cell of data in what you have listed as "Column 1" on Sheet2.

change A$1:$B$3 to the location of your table of data on Sheet1.

copy down.

It seems to work with:

=CERCA(A4;'Sheet1'!B2:B213;'Sheet1'!F2:F213)

Note:
A4 = firts cell with data in the column1 on sheet 2
B2:B213 = cells with data in the column1 on sheet 1
F2:F213 = cells with data in the column2 on sheet 1


N.B.: my Excel is in Italian, so the word "cerca" it should be your "vlookup"

Thanks
Diego