Do you mind blank that section out again and pasting all the hyperlinks in a seperate sheet so i can see what the file names are looking like
i'm only using mock data to do it ...i may be missing something in my assumption

with the search
it isn't doing exact match
it is using Instr function which does partial matches because it only search to see if the string exists in any part of the file name

so if you DH Lroberts or RobertsL DH or RoDHbLerts it would return all 3