The Excel Trainer
  • Live Training
  • Free Tutorials
  • Newsletter
  • Partners
  • Contact Mike
Select Page

Compare 2 Lists with the MATCH Function

Oct 12, 2013

A question that always gets asked on my Excel courses whenever I cover VLOOKUP is “I have 2 lists. There are some items that are the same on both lists. But there are some items on list 1 that aren’t on list 2. How can I quickly identify these?” The...

Recent Tutorials

  • Do You Want Early Access to Excel Updates?
  • Why You Should NOT Buy Excel 2019
  • Excel – Import a List of Tasks into Outlook
  • Excel – NEW in March 2018: Geography and Stock Data Types
  • Excel – Create a Pivot Table Using Excel Online
  • INDEX & MATCH v VLOOKUP / HLOOKUP
  • Excel Slicers – 2 Pivot Tables Based on Different Data Sources
  • Excel 2010 – Create a Combo Chart
  • Power Pivot and Power Query
  • Excel – What is a Dashboard?

© 2012-2021 - theexceltrainer.co.uk    Privacy Policy