Look in the help index for MATCH or VLOOKUP or use a FIND macro
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"C Kreig" wrote in message
...
I have two worksheets with thousands of items. I want to ID which assets
were added in 3.2.09 but are now gone 7.1.09.

Only serialized items are of interest.

I am trying to figure out which serial numbers are in both worksheets.
Can you please help.
Thank you in advance for your time.