Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Compare Two Lists Using the VLOOKUP Formula. That video is uploaded by Computergaga at 2014-11-04T14:29:46-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [GdrOFBBEMQ8]
| Name | Compare Two Lists Using the VLOOKUP Formula |
| Video Uploader | Video From Computergaga |
| Upload Date | This Video Uploaded At 04-11-2014 22:29:46 |
| Video Discription | 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 - https://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 ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Visit Computergaga For Lots More Tips https://www.computergaga.com Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 GdrOFBBEMQ8 |
| Category | Howto & Style |
| Tags | Microsoft Excel (Software) | vlookup formula | vlookup function | compare two lists | highlight missing items | conditional formatting | computergaga | vlookup formula between two worksheets | compare two lists in excel | compare two lists in excel for matches | compare two lists vlookup | excel for accounting | alan murray | excel for data analysis | compare two lists in excel for differences | compare two lists using the vlookup formula | conditional formatting compare two columns |
