haha no it seems to match 1 or two then returns no match for everything
else. thank you for your suggestions. I think if i appraoch it as
comparing records, using name as a unique identifier then checking to
see what are the unique iterations of it between the two worksheets.
I'll get there in the end I am hoping.