The UK's Leading Professional Training & Business Solutions Provider

Email or CALL NOW on 01952 581550

Excel – How to compare 2 lists

We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming an Excel Guru with this one!

This week’s tip is about how to compare 2 lists of data and see what’s in both lists (or what’s missing). It involves using complex formula that we learn on our Excel Guru’s course, and ‘nesting’ them so you can get the answers you want in plain English. We deal with the MATCH, ISNA and IF formulas in this short ‘How to’ video. If you have any questions contact me via our website.


If you would like a copy of the file I used in this exercise and step by step directions, sign up for our Tips & Tricks blog.

Contact us on 01952 581550 for course dates and learn Excel with us!

If this is useful to you, you can sign up to receive more free tips directly to your inbox!

You will also receive our Excel Cheat Sheet to get you started.