Comparing Heavy Lists - Please help!

[ToolroomSam]

Hi there, I hope you're well


I have a quick question to ask regarding comparing lists, if anyone would so lovely as to help me out...


I have 1 list compiled of around 2,000 lines of data and another list compiled of around 50,000 lines of data.


What I'm basically trying to do is find any information in the list of 2,000 lines of data within the list of 50,000.


Is this possible within Excel?


Thank you in advance for any help


Sam

 

[bobhc]

Good day toolroomSam


Try this link


http://chandoo.org/wp/2010/07/01/compare-lists-excel-tip/

 

[ToolroomSam]

I'll give this a go, thanks a lot or your help!