Finding a batch of numbers from one file on another without sear

Hi Daniel,

Thank you for the forum Question.

If you have a high level of VBA knowledge you can write VBA code, which can do what you want, otherwise you will need to copy the 225 lines and paste them in the same worksheet as the 4500 lines.

Select the long number column you want to pair in both lists. On the Home tab click conditional formatting -> Highlight Cell Rules -> Duplicate Values


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector