Return different matches that contains part of the searched text

Hello,

I have excel with column A and column C. Where A1=apple, A2=melon, A3=pear, A4=apple, A5=melon, A6=melon, A7=melon, A8=pear, A9=apple. C1=apple1, C2=apple2, C3=apple3, C4=apple4, C5=apple5, C6=pear1, C7=pear2, C8=pear3, C9=melon1, C10=melon2, C11=apple6, C12=apple7. I need a formula in B column, that returns the value from C column, that contains values from column A. Also I need it to return different results. For example, B1 must find apple (a1) that is containing in cell from C columns, that are "apple1", "apple2", "apple3", "apple4", "apple5", "apple6", "apple7", and must return "apple1", but B4 that has A4 "apple" also, must return "apple2", because "apple1" was already returned in B1.

I have attached the file, where in B colum I wrote what should be the results of the formula.

Thank you!

I mean instead of "1" inside "apple1" might be any text eg> "apple pie" or "apple plate". I need the formula to find "apple" inside "something apple something". And I need the formula not to return the same result it was matched above, eg if it returns "apple1" in B1 next to "apple (A1), it must not return the same "apple1" in B4, that is also next to "apple" (A4), but it must return "apple2" (that is from the list in C column), and B6 and B7 are #N/A because there are only 2 "melon" consisting in C column, "melon1" and "melon2" that are already matched in B2 and B5.

Well, I'll try to think of something better, but now, maybe try this in cell B1:
=XLOOKUP(TRUE,ISNUMBER(SEARCH(A1,$C$1:$C$12)),$C$1:$C$12,"",0)

then in cell B2:
=LET(a,$C$1:$C$12,b,FILTER(a,ISNA(MATCH(a,B$1:B1,0))),XLOOKUP(TRUE,ISNUMBER(SEARCH(A2,b)),b,"",0))
and copy down.