447,038 views
VLOOKUP in Excel - DON'T USE IT ANYMORE - Learn more here Excel Courses: https://swiy.co/cursos-ninja-youtube In this class, you will learn how to do VLOOKUP, but mainly you will understand the reasons why you should ABANDON VLOOKUP in Excel. I am a big fan of the VLOOKUP function, after all, it has been very useful to me for a long time. However, when you look at it in more detail and also compare it to other reference functions, VLOOKUP leaves a lot to be desired. That's why I created this video to show you the reasons NOT to USE VLOOKUP anymore. But don't worry, I'll give you some alternatives. As an alternative to VLOOKUP in Excel, we have the functions: INDEX AND MATCH IN EXCEL: This is the option I recommend the most currently, as it is compatible in all versions of Excel. The performance of these two functions makes everything easier, faster and more practical. XLOOKUP in Excel: This is a function that has certainly come to replace VLOOKUP. It is truly incredible and has a very interesting performance! I just don't recommend it so much yet, because it's a new function in Microsoft 365 (Office 365). So, not all versions of Excel will have this function. DOWNLOAD THE PDF HANDBOOK (SAMPLE): https://bit.ly/3gEqkeV FREE EXCEL COURSE: https://bit.ly/EXCEL-GRATUITO DOWNLOAD THE SPREADSHEET FOR THIS CLASS: https://1drv.ms/x/s!AmMwzGRjZm49gf9KD... Link to this class: VLOOKUP in Excel - DO NOT USE IT ANYMORE - Understand here • Quick Access Toolbar in Excel CLASS... 00:00 Subscribe to the Channel Are you already subscribed to the channel? Click here and subscribe: https://www.youtube.com/user/ninjadoe... ----------------------- EXCEL COURSES: https://swiy.co/cursos-ninja-youtube ----------------------- MY CONTACTS ▶ www.ninjadoexcel.com.br ▶ Facebook: http://www.fb.com/ninjadoexcel ▶ / edsoncavalcantejunior ▶ Email: [email protected]