Find duplicates in 2 columns and match values

**alex_uk** · 05-28-2018, 06:44 AM

Hi,

Have a problem there.
I have values 4 columns.
Column A - new reference number
Column B - Product name
Column C - Product name & old product names
Column D - Old reference numbers
Column E - column for a formula

What is the best way to match products by names and allocate new reference numbers?
Simple sorting by names won't help, because column has C has also old product names.
help.jpg

**sandy666** · 05-28-2018, 09:57 AM

Because you've Excel 2016 I can use PowerQuery aka Get&Transform

Please Login or Register  to view this content.

or with formula:

Formula:

Please Login or Register  to view this content.

If that takes care of your original question, & to say Thanks and for better Motivation, please

click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then
select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.

If you did it already - ignore it.
Thank you.

edit:
next time attach example Excel file but not a picture