In A3 copied down:

=MATCH("*"&B3&"*",$C$3:$C$24,0)

this will give you the row number within range C3:C24 where a match (if any) occurs.

Is that what you need?