"Fanney" wrote:
...
Max, This worked, when looking for the "short names" (list B) among the
"long names" (list A) :o) I now have a nice list of files registered in the
database, but missing on the drive.

Glad it helped !

However, looking for the long names among the short, is difficult, since
Excel can not distinguish which part of the long names it should be
searching for. Maybe I will just have to shorten all the long names, to mach
the short ones? I'm examining my options there.

Yes, it's tough. Perhaps you might want to put in a *new* post just
focusing on this topic. Post some samples of your actual data. Maybe other
responders could offer you their insights.

PS. Great web-site you have ..

Thanks. It's just a samples archive for ref by those interested.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---