Hi out there.
I wanted to ask if it is at all possible to compare info in one sheet to
info in another sheet (in the same workbook) when double info is not
necessarily located in the same cell in both sheets.

Background: I have one list of files registered in a data base and a list of
files actually on a hard drive. I need to compare the two list both ways to
check if there are any files on the drive, not registered in the data base
and, vice versa, if there are any files registered into the data base that
are not on the hard drive.

Any help would be greatly appreciated.