cell value dependant on lookup on another sheet

[stuclark]

I have 2 excel sheets for which I am interested in 4 columns. The issue I have is that the value of one column of cells on sheet2 should be set to the same as the value in the 2nd column on the 1st sheet where the values in both column 1's match.
There is no garauntee that the values within the 1st columns will be in the same order or that the number of rows is the same.


In the example below the value being inserted into col2 row 5 should be 1234.
Any one got any help?

SHEET 1


COL 1 COL 2
1 A 1234
2 B 12345
3 C 123456
4 D 1234567
5 E 12345678

SHEET 2


COL1 COL2
1 D
2 C
3 E
4 B
5 A 1234

stu

[NBVC]

Try VLOOKUP

e.g.

=VLOOKUP(A2,'Sheet1'!A:B,2,FALSE)

copied down