Compare two lists using the VLOOKUP formula in Excel. Use the VLOOKUP function to check two lists for missing items.
Learn it all with the Ultimate Excel course - bit.ly/UltimateExcel
In this video, the VLOOKUP function is used with the ISNA function and IF to return a value if an item was in one list, but not the other.
We then look at using VLOOKUP with Conditional Formatting to highlight the row of the missing item in a different colour. The list can then be filtered to explore the list differences.
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Visit Computergaga For Lots More Tips
computergaga.com
Connect with us!
LinkedIn ► linkedin.com/company/18737946/
Instagram ► instagram.com/computergaga1/
Twitter ► twitter.com/computergaga1
- Compare Two Lists Using the VLOOKUP Formula ( Download)
- How to Use VLOOKUP to Compare Two Lists ( Download)
- How to Do a VLOOKUP With Two Spreadsheets in Excel ( Download)
- Excel: Compare two columns using Vlookup ( Download)
- Excel - Compare 2 Lists with a VLOOKUP - Episode 1534 ( Download)
- Excel - Compare Two Lists with the VLOOKUP Function ( Download)
- Use Vlookup to compare two lists in excel ( Download)
- Use VLOOKUP or XLOOKUP to Compare Two Lists For Matches or What Is Missing ( Download)
- Match Names on Two Excel Sheets with VLOOKUP – Create Unique ID in Excel ( Download)
- Compare two lists with a simple Vlookup in Microsoft Excel ( Download)
- How to compare two columns in different Excel sheets using Vlookup ( Download)
- Compare Two Lists and Find Matches & Differences with 1 Formula - Excel Magic Trick ( Download)
- How to compare two tables in excel using VLOOKUP ( Download)
- HOW TO: compare two columns in Excel using VLOOKUP ( Download)
- Compare Two Columns in Excel (for Matches & Differences) ( Download)
