Malcolm M wrote:
|| I have two storerooms in the same workbook (separate worksheets) and
|| need to find shared items that have different item numbers (the
|| column names in each sheet match.) I can use the FIND function to
|| locate individual shared items in both storerooms, but with over
|| 4,000 items, I'm hoping for a faster method.

Have a look he
http://www.cpearson.com/excel/duplic...tingDuplicates

--
Gordon Burgess-Parker
Interim Systems and Management Accounting
www.gbpcomputing.co.uk