How to extract data when there are duplicates

[SuzanneLedo]

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!

[#2 · Accepted solution]

You may simply try this... In C2 =INDEX(Sheet2!B:B,MATCH($A2,Sheet2!$A:$A,0)) and then copy it across and down.

[#3]

@Subodh_Tiwari_sktneer Thank you so much for your response. It worked! I knew I had to use INDEX but the formula was tricky.

[#4]

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