hi gurus!

im stuck trying to figure out a formula.

i have a list of name with unit number in column C eg ; a1-2-3 ABC condominium
and in column z a list of condominium names which i want to match and output would be the best match of column C and column Z