Partial Match Index Left Mid 2 sheets

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]
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top