Macro to VLOOKUP values from one worksheet to another

[platoniciorf]

I have two worksheets. Both worksheets have a column with the the same reference numbers. Those reference number will then be used as point of reference to pick up values in the same row as the reference number from one worksheet to another. Is there a way to do this using a macro? Please help me on this. Thanks!