Excel Problem Solving | Compare Excel Data Using VLOOKUP, IF and ISERROR Excel Functions

This video explain the smartest method to compare two different data from sheets or from Excel files using #Vlookup formula with the help of #If and #Iserror formula. Using these simple formulas, you able to compare and find out the wrong data. SUBSCRIBE TO THIS CHANNEL https://youtube.com/prabasmsoffice/?sub_confirmation=1 Join us to show your love and support: https://www.youtube.com/channel/UCE37kYsUhsxDB0-IlB6zwMQ/join https://youtu.be/wW-AylK48M8 Make sure to download and use the practice file from the following path for better understanding : https://prabastech.com/downloadable-excel-supporting-files-archived-2/ #CompareExcelData #ExcelToCompare #Vlookup Topics Covered in this video: 0:00 - Introduction of this comparison method 0:50 - Explaining the Requirement 1:30 - Understand and start comparing 3:17 - Creating Helper Column in Microsoft Excel 4:00 - Creating Vlookup excel formula 6:19 - Enhancing the output using IF and Iserror excel functions 8:54 - How do you ask your doubts with Prabas MS Office All Videos of Prabas Microsoft Office in Tamil – தமிழ்: https://www.youtube.com/watch?v=w1QvylCR9TI&list=PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH #Excel #PowerPointTraining #WordTraining #PrabasMSOffice #PrabasTech #PowerQuery #FreeDownloads #Office365