Try this formula:
=IF(ISERROR(MATCH("*"&LEFT(C6,16)&"*",B:B,0)), "No", "Yes " &MATCH("*"&LEFT(C6,16)&"*",B:B,0))