thanks nbvc for your help, appreciate your time

however, would like it to return all values in column c, which are not in column a, where column c and and column A have a partial match.

see column f on spreadsheet, for actual desired result.

sorry if i wasnt clear first time.