Download Excel File: https://excelisfun.net/files/EMT1750.xlsx
Learn how to compare to lists and extract items in both lists, or exact the items that are not in both lists. Formula #1: Extract items in List 1 that are in List 2. Formula #2: Extract items in List 1 that are NOT in List 2.
1) (00:00) Intro
2) (00:30) Formula to extract items in both lists for versions of Excel other than Microsoft 365.
3) (00:40) Formula to extract items in both lists using XMATCH, ISNUMBER and FILTER.
4) (02:22) Formula to extract items NOT in both lists using XMATCH, ISNA and FILTER.
5) (02:44) Conclusion and video links

Link to video that shows 6 ways to compare two lists if you do not have Microsoft 365 Excel: https://www.youtube.com/watch?v=9h1omv60MCA