Hi Will,

What do you want to do with them when you find them?

For example you can count the number of times items in first
list appear in your second list like this,

Assuming
Sheet1 values in A1:A3000
Sheet2 values in A1:A12000

Put this in Sheet1 cell B1
=COUNTIF(Sheet2!$A$1:$A$12000,A1)
And drag it down to B3000 (or just double click on the fill handle)

HTH
Martin

"willirwin" wrote in message
...
I have to worksheets the have of 3000 entries and I need to compare it to
another worksheet that has over 12000 and I need to find the same infor on
both is there a way to sort this out.