CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE BASIC EXCEL MINI COURSE: https://pages.hashtagtreinamentos.com... BASIC EXCEL HANDBOOK [FREE DOWNLOAD]: https://www.hashtagtreinamentos.com/h... ----------------------------------------------------------------------- ► To Download the File Used in the Class, Access: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/p... ----------------------------------------------------------------------- Recommended Videos: ► The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP vo... ► VLOOKUP - Complete Step by Step (without complications) • VLOOKUP - Complete Step by Step (without c... ► Pivot Table - How to make an Excel Pivot Table in 5 steps! • Pivot Table - How to make a Pivot Table... ► EXCEL SPREADSHEET to IMPRESS ANYONE • EXCEL SPREADSHEET to IMPRESS ANYONE... ► Learn EVERYTHING about how to create GRAPHICS in EXCEL • Learn EVERYTHING about how to create GRAPHICS... ----------------------------------------------------------------------- Hey Impressives! In today's class I want to show you all the Excel PROCs, that is, I'll show you VLOOKUP, HLOOKUP, XLOOKUP and PROC! These are functions that you've probably heard of, especially VLOOKUP which is the best known, but I want to show you how each of them works within Excel. The VLOOKUP function in Excel, which is the most common, will perform a vertical search, while the HLOOKUP function in Excel will perform a horizontal search. The XLOOKUP function in Excel is a newer function and came to replace both the VLOOKUP formula and the HLOOKUP formula. This means that with a single formula you can perform both a vertical search and a horizontal search in a much easier way and without the restrictions of the VLOOKUP and HLOOKUP functions. To finish, I will talk about the LOOKUP function in Excel, which is actually a function that came before VLOOKUP and VLOOKUP. It is still available for compatibility reasons. How so? If you have an older file that uses this function, it will continue to work without any problems! ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► Blog: https://bit.ly/2MRUZs0 ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ► Tik Tok: https://bit.ly/3dUpwkW To receive daily Microsoft Excel, VBA and Power BI content for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... In our videos we teach several Excel tips and tricks in Excel so that you can develop and impress with this tool even if you have little or no knowledge of Excel! ----------------------------------------------------------------------- Class Content 00:00 Introduction 00:56 VLOOKUP Function in Excel (Vertical Search) 10:08 HLOOKUP Function in Excel (Horizontal Search) 17:20 XLOOKUP Function in Excel (Vertical and Horizontal Search) 22:23 LOOKUP Function in Excel 23:49 Conclusion #excel #microsoftexcel #hashtagtrainings