Microsoft Excel Tips and Tricks
In this Microsoft Excel video tutorial I explain how to use VLOOKUP or XLOOKUP to compare two lists. Using this method you will be able to see matches and what is missing. Your two lists may be on the same worksheet, on different worksheets in the same workbook or in different workbooks.
Credit Chester Tugwell