Forum Discussion
Solved
How to extract data when there are duplicates
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 de...
- You may simply try this... In C2 =INDEX(Sheet2!B:B,MATCH($A2,Sheet2!$A:$A,0)) and then copy it across and down.
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.