Hi,

Kind of a xls noob. I search for an answer but didn't find what I was looking for.

Here's the scenario:
Compare 2 worksheets and pull common data from both and add to 3rd worksheet.

Data:
Multiple rows
Using columns A thru T
Primary column for query A (text alphanumeric)

Example:

Sheet 1

Col A
GC1
GC2
GC3
GC7
GC8
GC9

Sheet 2

Col A
GC2
GC4
GC7
GC10
GC11

Results

Col A
GC2
GC7

Thank in advance for your help.

Bren