Cross Checking

[workindan]

For some reason I can't seem to get formulas or macro's cross checking two sheets...

Sheet1, Column A:
032131321
608948905
651310533
.....
Sheet2, Column A:
321561061
135165135
132151355
.....
(Sheet2 ColumnB - F has needed data, Column A is just for matching)

There's 4000 on Sheet1 and 160000 items on sheet 2. I need to identify which items on Sheet 2 exist on Sheet 1. (Once identified copy Sheet1 and Sheet 2 row to a new sheet probably. Sheet1RangeA and Sheet2RangeA:F to new sheet)

What's the most efficient way to do this?

 

[VoG]

Possibly VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[workindan]

I've tried on Sheet 1....

=VLOOKUP(A2,Sheet2!$A$2:$A$148323,1)
=VLOOKUP(A3,Sheet2!$A$2:$A$148323,1)
=VLOOKUP(A4,Sheet2!$A$2:$A$148323,1)

But all I get is N/A. I've made sure Column A on both sheets are formatted as text.