Search column for text string and return row number

I am looking for a formula to search for a text string from cells in one column within cells of another column in a separate sheet. I have two sets of data: Sheet1!C10:C1656 and Sheet2!G2:G2720. I want to see if each cell in Sheet1 column C exists as a string within cells of Sheet2 column G, and if so, return the corresponding row number. For example, Sheet1!C17 = "1587"; Sheet2!G643 = "1587 Skin Roast Flr Plan.pdf". The text string will not necessarily start in position 1. A formula would exist in Sheet1 column A, and result would be row "643".

MATCH can do this when using "*" to "wildcard", like this:

Please Login or Register  to view this content.

see attached example file

@TMS, due to data starting on row 2, to return the row number, shouldn't the formula account for an offset with "+1"?
like this:

Please Login or Register  to view this content.

@TMS, haha, yes you beat me while i was typing. good solution

Thank you all, simple and effective solutions. I was trying to overthink it, and forgot about using wildcard with Match.