Hi Claus,
I was not fully advised of the results criteria.
Nme's CAN occur more than once in sheets Input, column A.
Also, if no match found on Output sheet, the "no match" is listed as a result with the resize data cells blank.
Yellow cells on Input sheet have no match on Output sheet and ARE listed in Column C returns.
My attempt to rewrite the code does zip!
Thanks.
Howard
https://www.dropbox.com/s/jyawocfar9...Copy.xlsm?dl=0