Partial Match Index Left Mid 2 sheets

[Lisa Urban]

I am working with 2 Sheets in a workbook.

I am attempting to run a PARTIAL MATCH from SHEET1, COLUMN C to SHEET2, COLUMN A. When there is a match of 5 digits, I want the value in SHEET2, Column B in the same row as the match, to be placed in COLUMN G of the row matching SHEET1, Column C. I have tried numerous iterations and continue to received #n/a results. The closest I have come, resulted in the first value of B2 from SHEET2, but it was not a match to anything. This was that formula =INDEX(RetouchersTime!B:B,MATCH(LEFT(C238,5)*1,RetouchersTime!A:A,1))

Please help? Thank you in advance.

SHEET 1

A	B	C	D	E	F	G
		51824EMK Wonderlust_Wonderlust_Eau_Fresh_ <tbody> </tbody>			85.79 <tbody> </tbody>	(here is where I want to value)
		51857DC DKNY_Stories_Scentseal_Magazine_L <tbody> </tbody> <tbody> </tbody>			99.43 <tbody> </tbody>
		51880EMK MK_EauFresh_Scent_Seal_Magazines <tbody> </tbody>			199.79 <tbody> </tbody>
		51916EMK MK_Wonderlust_Eau_Fresh_Dual_Sce <tbody> </tbody>			22.44 <tbody> </tbody>

<tbody>
</tbody>

SHEET 2

A	B
Aramis Service Agreement:ASA - Donna Karan Urban: 51916EMK MK_Wonderlust_Eau_Fresh_Dual_Sce <tbody> </tbody> <tbody> </tbody>	$7,042.34
Bobbi Brown:51824EMK Wonderlust_Wonderlust_Eau_Fresh_ <tbody> </tbody>	$24,852.13
Aramis Service Agreement:ASA - Michael Kors Urban:Aramis Service Agreement:51538EMK FY19_MK_Sky_Blossom_Campaign_SA <tbody> </tbody>	$131.89
Aramis Service Agreement:ASA - Tommy Hilfiger Urban: <tbody> </tbody> 51880EMK MK_EauFresh_Scent_Seal_Magazines <tbody> </tbody>	$1,008.92

<tbody>
</tbody>