Hi,

I have a value in A1 on Sheet1 of a workbook and, for each instance of the same value in column D on Sheet2, I need to copy the values in the next 2 adjacent cells and paste them to Column K-L on Sheet3. I'm guessing that FIND is a better way than using vlookup but then I get totally lost. Can anyone help please?

Many thanks