How to extract data when there are duplicates

New Contributor

I'm using Windows 10 and Excel 365 enterprise.  I have a sheet with duplicate entries and I need to copy data from a sheet with matching unique entries and repeat it on each line without having to delete the duplicates.   Example attached.  


Thanks in advance for any assistance!

3 Replies
best response confirmed by SuzanneLedo (New Contributor)
You may simply try this... In C2 =INDEX(Sheet2!B:B,MATCH($A2,Sheet2!$A:$A,0)) and then copy it across and down.
@Subodh_Tiwari_sktneer Thank you so much for your response. It worked! I knew I had to use INDEX but the formula was tricky.

You're welcome @SuzanneLedo! Glad it worked as desired.