Forum Discussion
Solved
Formula look at sheet 1, find duplicates in sheet 2 and copy ID from sheet 1 to each duplicate
I am using Excel 2016 and I am in over my head on this. I am trying to write a formula to look at Sheet 1 Column B and for every duplicate in Sheet 2 Column B it will copy the unique anchor/ID Nu...
You may enter into Sheet2!A2
=INDEX(Sheet1!A:A,MATCH(Sheet2!$B2,Sheet1!B:B,0))and drag it down
Hi Sergei
Your formula works perfectly and does exactly what I need.
Thank you so much and I really appreciate your help.
Kind regards Bel
Bel, you are welcome, glad to help