Función BUSCARX en Excel | La MEJOR FÓRMULA Para Buscar Valores En Excel

Forget about using VLookup and use the XLOOKUP function instead. In this video, you'll learn how to use Excel's best formula for searching for values, which is XLOOKUP, since it has much more power and is easier to use than VLOOKUP. With XLOOKUP, you can search for values in a variety of ways and return results that are either to the right or left of the searched value. You can search for values vertically and horizontally, etc. This function is ideal for those who want to improve their data searching skills and can replace other functions like VLookup, HLOOKUP, or Index & Match because it is much more effective. The XLOOKUP function is available starting with Excel 2021, in Excel on the web, and in Microsoft 365. You'll be amazed at how amazing this function is! ✅ I'm sharing the link to the practice file: https://docs.google.com/spreadsheets/... 🖕 To download it, go to File, Download, Microsoft Excel. 🙏 Support the Channel by clicking the THANK YOU button in the video. 0:00 Introduction 0:35 Availability of the LookupX function 1:27 Why is LookupX better than VLookup? 2:10 Converting your database to a table 2:38 How to use the LookupX function 4:24 What to enter if no values are found? 5:10 How to do horizontal searches with LookupX 6:47 Matching mode with LookupX (approximate match) 10:07 Search mode with LookupX (from first to last or vice versa) 💡 If you don't have Excel 2021, then watch this video to download and install it for FREE and LEGALLY:    • Como Descargar e Instalar OFFICE 2021 GRAT...   Other Excel videos that might interest you: ✅ VLOOKUP function in Excel:    • Función BUSCARV en Excel – COMPLETO Y BIEN...   ✅ FILTER function in Excel:    • Todo sobre la Función FILTRAR en Excel - ¡...   ✅ How to make a Dynamic Lookup in Excel:    • Cómo Hacer un BUSCADOR DINÁMICO en Excel d...   ✅ How to make a Dashboard from scratch in Excel:    • Cómo Crear un IMPRESIONANTE DASHBOARD Diná...   ✅ How to make a Diagram Gantt chart in Excel:    • Cómo hacer un DIAGRAMA DE GANTT en EXCEL (...   #excel #microsoftexcel #tutorial