Download the featured file here: 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
------------------------
- Use VLOOKUP or XLOOKUP to Compare Two Lists For Matches or What Is Missing ( Download)
- Compare Two Lists Using the VLOOKUP Formula ( Download)
- How to Use VLOOKUP to Compare Two Lists ( Download)
- Compare two lists to find missing values using XLOOKUP in Excel - Excel Tips and Tricks ( Download)
- Compare Two Lists and Find Matches & Differences with 1 Formula - Excel Magic Trick ( Download)
- Compare two lists to find missing values using VLOOKUP in Excel - Excel Tips and Tricks ( Download)
- How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples) ( Download)
- How to Do a VLOOKUP With Two Spreadsheets in Excel ( Download)
- Find Multiple Matching Values in Excel and Highlight - Match & Highlight Names from Two Sheets ( Download)
- How to compare two lists to find missing values in excel ( Download)
- XLOOKUP with Multiple Conditions ( Download)
- How to Use Excel XLOOKUP and XMATCH Functions ( Download)
- Match Names on Two Excel Sheets with VLOOKUP – Create Unique ID in Excel ( Download)
- Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial ( Download)
- How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP ( Download)
