Index Match with wild card help

rennerom

New Member
Joined
Apr 23, 2015
Messages
1
I'm working on a project which provides two excel files. The first file, File1, contains a list of SKU descriptions under the header "SKU". They are somewhat long, and contain superfluous information.
SKU(A1)
M GEL-CUMULUS 14
M GEL-CUMULUS 15
M GEL-CUMULUS 16 BR
W SUPERNOVA GLIDE 6
W SUPERNOVA GLIDE BO

<tbody>
</tbody>

<tbody>
</tbody>
I have another file, File2, that contains more general descriptions under the header "Model", and provides dates when a model gets updated.

Update(A1)Model(B1)
6/1/15Cumulus
9/1/15Glide

<tbody>
</tbody>


What I'm trying to do, is add the date from File2 to File1 in column B, based on the indexing the model names, and partially matching them to the SKU column from File1.

My first inkling was to index match with a wild card, but I can't seem to get anywhere.

=INDEX(File2.csv!A:A,MATCH(A2&"*",File2.csv!B:B,1))

Every time I try this, I only get 2 dates, and they're not correct. All other forms I've tried just yield N/A or Ref conflicts. Should I rename the the cells under Model to be a little closer to the SKU descriptions? Like GEL CUMULUS in stead of CUMULUS, or SUPERNOVA GLIDE instead of GLIDE. I don't need the gender qualifier (M/W) or model number (14, 15, etc...).
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,215,772
Messages
6,126,812
Members
449,339
Latest member
Cap N

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