Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/02/use-vlookup-to-compare-two-lists.xlsx

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.

Table of Contents:

00:00 - Introduction
00:18 - VLOOKUP to compare two lists on the same worksheet
01:51 - Use IF ISNA formula to customise VLOOKUP results
03:02 - XLOOKUP to compare two lists on the same worksheet
04:08 - VLOOKUP to compare two lists in different worksheets
05:14 - Use named reference for table array in VLOOKUP
07:04 - VLOOKUP to compare two lists in different workbooks
08:27 - Refer to a named reference in a different workbook
------------------------