Check for a number of matching characters return value (if match is found) and location

[Reu]

Here is the formula I have so far:

=IF(ISERROR(MATCH("*"&LEFT(C3,16)&"*",B:B,0)), "No", VLOOKUP(C3,B:B,1,FALSE))

My goal:

1) See the first 15 characters of cell C3 match any cell in column B.
2) If no match is found return "No" to the cell where this formula is placed (D3).
3) If a match is found return "Yes" to the cell where this formula is placed (D3), AND return the matching cell number from column B to the cell adjacent to the cell where this formula is placed (E3).
. . .or to the same cell where this formula is placed.

[p24leclerc]

Try this formula:

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