I am trying to compare 2 worksheets for similar data. I have serial numbers
in column L on Sheet1 and serial numbers in column B on Sheet 2. I want to
look for duplicated serial numbers on both worksheets. I need a formula that
will search both Sheets for any duplicated serial numbers. When duplicate
serial numbers are found, I want the data in column C (Found Date) on sheet2,
to auto fill column H (Found Date) on Sheet1.
Jeff W