emilyshaw93
New Member
- Joined
- Nov 11, 2015
- Messages
- 18
Hi there,
I have 2 sheets, one called 'Scraping List' and one called 'Initial List'.
I need a formula that searches whether a name listed in Col B of 'Scraping List' matches any entry into the 'Initial List' names in Col E of that sheet.
Every name on the 'Initial List' sheet has a corresponding document reference in cell D next to it. If there is an exact match between the names in both Col B of 'Scraping List' and Col E of 'Initial List', I need the document reference of matching names in Col D of 'Initial List'. Hope this makes sense - there will be lots of them, I imagine. The result must go into Col G in 'Scraping List' doc, so that all doc ref numbers relating to a name are compiled into one cell.
It would also be good if they could be ordered and duplicates removed, but if they can't then don't worry!
Any help much appreciated
I have 2 sheets, one called 'Scraping List' and one called 'Initial List'.
I need a formula that searches whether a name listed in Col B of 'Scraping List' matches any entry into the 'Initial List' names in Col E of that sheet.
Every name on the 'Initial List' sheet has a corresponding document reference in cell D next to it. If there is an exact match between the names in both Col B of 'Scraping List' and Col E of 'Initial List', I need the document reference of matching names in Col D of 'Initial List'. Hope this makes sense - there will be lots of them, I imagine. The result must go into Col G in 'Scraping List' doc, so that all doc ref numbers relating to a name are compiled into one cell.
It would also be good if they could be ordered and duplicates removed, but if they can't then don't worry!
Any help much appreciated