Matching columns between work sheets

Hi all,

I've been struggling with a macro and decided it's beyond me. What I need to do is this;

For each value in column A of sheet 1
If that value is present somewhere in column A of sheet 2 then
copy that whole row (from sheet2) into sheet3
Else
do nothing
next value

So in sheet3 I should end up with all of the rows from sheet2 where the value in the A column was found in column A of sheet1.

I'm not asking anyone to write the macro for me, but I need some help on how to do it. I've tried using the two LOOKUP commands but I'm not getting anywhere fast.

Use the Find method, not VLOOKUP.

Got it. I used this type of lookup taken from another thread;

=IF(ISERROR(MATCH(A1,B1:B100,0)),"Unique","Match")

That's a worksheet function construct, not a VBA construct.