Approximate match in power query

secriera

New Member
Joined
Mar 24, 2018
Messages
1
Hello everyone,

I have 2 columns in power query.
I want to assign the best approximation to column 1 from column 2

For example: For the phrase column 1 https://www.screencast.com/t/KafThnRPS
Best match is https://www.screencast.com/t/CZiJINVA20v

in column 1 can be from 1 to 4 words compatible with column 2

Column 1

BoboBaby patchwork jucarie plusata - ursulet ZW-19D
Klups set lenjerie 3 piese My Teddy bej
Klups set lenjerie 3 piese Little house
Klups set lenjerie 3 piese Arici alb
Klups set lenjerie 3 piese Indian Boy
Klups set lenjerie 3 piese Choo-Choo galben-gri
Klups set lenjerie 3 piese Baloons
Klups set lenjerie 3 piese Choo-Choo - pink/grey
Klups set lenjerie 4 piese Little Bunny gri-pink
Klups set lenjerie 4 piese Little Bunny bej-blue
Klups set lenjerie 4 piese Little house
Klups set lenjerie 2 piese Elefantul si Prietenii roz
Klups set lenjerie 2 piese Little Bunny gri-pink
Klups set lenjerie 5 piese Elefantul si Prietenii blue
Klups set lenjerie 5 piese Elefantul si Prietenii roz
Klups set lenjerie 5 piese Little Bunny gri-pink
Klups set lenjerie 5 piese Little Bunny bej-blue
Klups set lenjerie 5 piese Little Bunny bej-pink
Klups set lenjerie 5 piese My Teddy bej
Klups set lenjerie 5 piese Little house
Klups set lenjerie 5 piese Arici alb
Klups set lenjerie 5 piese Bufnite
Klups set lenjerie 5 piese Triunghiuri pink/grey
Klups set lenjerie 5 piese Indian Girl
Klups set lenjerie 5 piese Indian Boy
Klups set lenjerie 5 piese Choo-Choo - pink/grey
Klups set lenjerie 5 piese Teddy Moon - blue/white
Klups set lenjerie 5 piese Kitties
Klups set lenjerie 5 piese Choo-Choo galben-gri
Klups set lenjerie 5 piese Baloons
Klups set lenjerie brodata 4 piese Sleeping Teddy Bear pink
Klups set lenjerie brodata 4 piese I love you ursulet alb-bej
Klups set lenjerie brodata 5 piese I love you ursulet alb-bej
Klups set lenjerie brodata 5 piese I love you ursulet roz
Klups set lenjerie brodata 4 piese I love you ursulet blue
Klups salteluta de infasat moale PM70 - Animale din padure si arici 70*50 cm
Klups salteluta de infasat moale PM70 - 016 Elefant 70*50 cm

<colgroup><col></colgroup><tbody>
</tbody>

Column 2

Scaun Multifunctional
Scaun de Masa din Lemn
Scaun de Masa cu Leagan
Gentuta de Infasat
Lenjerie Patut Bebe 3 Piese
Lenjerie Patut Bebe 4 Piese
Lenjerie Patut Bebe 2 Piese
Lenjerie Patut Bebe 5 Piese
Lenjerie Patut Bebe 6 Piese
Lenjerie Patut Bebe 7 Piese
Ham Bebe
Centura Abdominala Postnatala
Centura Prenatala
Sutien Alaptare
Chiloti Gravide
Lenjerie Unica Folosinta
Patut Masina Copii
Premergatoare 3 in 1
Antepremergator

<colgroup><col></colgroup><tbody>
</tbody>



<colgroup><col></colgroup><tbody>
</tbody>
Thanks
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,123,176
Messages
5,600,154
Members
414,367
Latest member
dw970906

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
Top