Скачать с ютуб How to use XLOOKUP in Excel | BYE BYE VLOOKUP & HLOOKUP в хорошем качестве

How to use XLOOKUP in Excel | BYE BYE VLOOKUP & HLOOKUP

In this video we will learn about XLOOKUP. XLOOKUP is a modern replacement for the VLOOKUP function. It is a flexible and versatile function that can be used in a wide variety of situations. XLOOKUP can find values in vertical or horizontal ranges, can perform approximate and exact matches, and supports wildcards (* ?) for partial matches. In addition, XLOOKUP can search data starting from the first value or the last value (see match type and search mode details below). Compared to older functions like VLOOKUP, HLOOKUP, and LOOKUP, XLOOKUP offers several key advantages. Download the excel file from the link below: https://bit.ly/3hJ7PcA 00:00 Intro 01:09 Normal Lookup 01:53 Lookup Left to Right 02:39 Lookup with Nearest Value 04:29 Partial Match (Wild Card) 05:40 Lookup from Bottom to Top Check these videos to learn more : 1 Min Excel: If you enjoy short videos check this section    • Shorts : Random   Excel: Check this playlist for Excel-related things    • Excel   Keyboard Shortcuts: Check this section to save some time in everyday excel work    • Excel Keyboard Shortcuts   Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports    • Pivot Tables   Power Query: Check the Power Query playlist for Data Preparation & its Automation    • Power Query   Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations    • Power BI   Please subscribe to our channel and Follow us on other social media platforms for regular updates : Tiktok https://vm.tiktok.com/ZSH28XEt/ Facebook   / datacense   Twitter   / datacense   LinkedIn   / datacense   Instagram   / datacense32