how to find substring in a list and show a cell from matching line in excel

I have a list of id's in column A (gene1, gene2,...) followed by list of description in column B (gene_id=1234 gene_locus=gene1, ...) and also a sub string(1234, ...) which is in column C, I would like to search the column B for the substring of column C and if matches show the column A's matching line in column D.

For example here, I would like to get gene1 in column D in the same line where you see 1234.

I have already tried to count the matching line but wont do the thing I want

=COUNTIF(A1:A7775,"*"&C1&"*")>1