Find Query

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

Yes, it looks like. Could you please attach a sample book with a desired result?

Many thanks in anticipation, here's a workbook which i've simplified for this purpose

M

Book1.xls

Mike,
Try this one and see how it goes.

Please Login or Register  to view this content.

Many thanks!! This almost works perfectly. It copies the column headers each time it runs for some reason though

Mike! Sorry Mate!
It was actually a wrong code. The code was looking at Columns "B", instead of D.
I think this is correct.

Please Login or Register  to view this content.

Hi, apologies for the delay getting back to you. Your re-posted code works perfectly! Many thanks again for your help