Find and replace

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

Please Login or Register  to view this content.

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

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