Forum Discussion
Solved
Find duplicates in 2 columns and match values
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 Colu...
Hi Alex,
That could be
=IFERROR(INDEX(A:A,MATCH($C2,B:B,0)),"")
for E2 and drag it down
Hi Alex,
That could be
=IFERROR(INDEX(A:A,MATCH($C2,B:B,0)),"")
for E2 and drag it down
- Thank you! Perfectly works!!!!
