Find and replace

[Brewel]

Hello,

I am fairly new to VBA to please excuse me if I do not explain my problem clearly.

I have 2 columns of data in sheet 1.
On sheet 2 I also have 2 columns of data.
I would like to find a way of matching the values in the cells of sheet 1 column 1 with the values from same column in sheet 2 i.e column heading "Test#". When a match is found, I need to take the corresponding value from the 2nd column(sheet 2) and paste it into the corresponding 2nd column(Time) in sheet 1.

I have tried to do this already with findandreplace and the offset function, but I cannot put the replacement value into the right cell.

Is there a way to do this, or do I need to find another method.

example layout

Sheet1                                         Sheet2
Test #	Time(mins)			Test #	Plate
1	            5			          1	          A
1	            6			          2	          B
1	            7			          3	          C
1	            8			          4	          D
2	            10				
2	            11				
2	            12				
2	            13				
3	            15				
3	            16				
3	            17				
3	            18				
4	            20				
4	            21				
4	            22				
4	            23

[JBeaucaire]

Via formula, on sheet1 B2 put this formula, then copy down:

=VLOOKUP(A2, Sheet2!$A:$B, 2, 0)

[Brewel]

Thank you for your quick reply.

That function works perfectly for me.