Lisa Urban
New Member
- Joined
- Jun 29, 2018
- Messages
- 1
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51824EMK Wonderlust_Wonderlust_Eau_Fresh_[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl109, width: 65, align: right"]85.79 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD](here is where I want to value)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51857DC DKNY_Stories_Scentseal_Magazine_L[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl109, width: 65, align: right"]99.43 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51880EMK MK_EauFresh_Scent_Seal_Magazines[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl109, width: 65, align: right"]199.79 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51916EMK MK_Wonderlust_Eau_Fresh_Dual_Sce[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl109, width: 65, align: right"]22.44 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
SHEET 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][TABLE="width: 809"]
<tbody>[TR]
[TD="class: xl109, width: 809"]Aramis Service Agreement:ASA - Donna Karan Urban:[TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51916EMK MK_Wonderlust_Eau_Fresh_Dual_Sce[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$7,042.34[/TD]
[/TR]
[TR]
[TD][TABLE="width: 809"]
<tbody>[TR]
[TD="class: xl109, width: 809"]Bobbi Brown:51824EMK Wonderlust_Wonderlust_Eau_Fresh_[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$24,852.13[/TD]
[/TR]
[TR]
[TD][TABLE="width: 809"]
<tbody>[TR]
[TD="class: xl109, width: 809"]Aramis Service Agreement:ASA - Michael Kors Urban:Aramis Service Agreement:51538EMK FY19_MK_Sky_Blossom_Campaign_SA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$131.89[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 809"]
<tbody>[TR]
[TD="class: xl109, width: 809"]Aramis Service Agreement:ASA - Tommy Hilfiger Urban:[/TD]
[/TR]
</tbody>[/TABLE]
51880EMK MK_EauFresh_Scent_Seal_Magazines[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$1,008.92[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51824EMK Wonderlust_Wonderlust_Eau_Fresh_[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl109, width: 65, align: right"]85.79 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD](here is where I want to value)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51857DC DKNY_Stories_Scentseal_Magazine_L[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl109, width: 65, align: right"]99.43 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51880EMK MK_EauFresh_Scent_Seal_Magazines[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl109, width: 65, align: right"]199.79 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51916EMK MK_Wonderlust_Eau_Fresh_Dual_Sce[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl109, width: 65, align: right"]22.44 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
SHEET 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][TABLE="width: 809"]
<tbody>[TR]
[TD="class: xl109, width: 809"]Aramis Service Agreement:ASA - Donna Karan Urban:[TABLE="width: 21"]
<tbody>[TR]
[TD="class: xl109, width: 21"]51916EMK MK_Wonderlust_Eau_Fresh_Dual_Sce[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$7,042.34[/TD]
[/TR]
[TR]
[TD][TABLE="width: 809"]
<tbody>[TR]
[TD="class: xl109, width: 809"]Bobbi Brown:51824EMK Wonderlust_Wonderlust_Eau_Fresh_[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$24,852.13[/TD]
[/TR]
[TR]
[TD][TABLE="width: 809"]
<tbody>[TR]
[TD="class: xl109, width: 809"]Aramis Service Agreement:ASA - Michael Kors Urban:Aramis Service Agreement:51538EMK FY19_MK_Sky_Blossom_Campaign_SA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$131.89[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 809"]
<tbody>[TR]
[TD="class: xl109, width: 809"]Aramis Service Agreement:ASA - Tommy Hilfiger Urban:[/TD]
[/TR]
</tbody>[/TABLE]
51880EMK MK_EauFresh_Scent_Seal_Magazines[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$1,008.92[/TD]
[/TR]
</tbody>[/TABLE]