Microsoft Excel - The XLOOKUP Function скачать в хорошем качестве

Microsoft Excel - The XLOOKUP Function

By Andrew Gould Download files here https://www.wiseowl.co.uk/excel/video... If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:    / @wiseowltutorials   Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Learn how to use the XLOOKUP function in Microsoft Excel to lookup and return values. XLOOKUP combines features of VLOOKUP, HLOOKUP, MATCH and INDEX as well as more advanced features. You'll learn how to lookup values vertically or horizontally and in both dimensions in the same formula. You'll see the difference between exact match and range lookups and learn how to use wildcard characters when searching in text columns. Chapters 00:00 Topic List 00:45 A Basic XLOOKUP Formula 03:12 Using Named Ranges 05:00 Returning Values from the Left 05:58 Dealing with No Matches 06:59 Looking Up Formula Results 08:06 Returning Multiple Columns 10:33 Looking Horizontally 12:39 Returning Multiple Rows 13:43 Returning a Reference to a Range 16:17 Summing Across a Lookup Range 18:21 Looking in Two Dimensions 20:56 Reversing the Row and Column Lookup 22:07 Creating a Range Lookup 26:13 Descending Range Lookups 28:47 Linear vs Binary Search Mode 30:37 Using a Wildcard Match 33:36 Searching From the Bottom 35:08 Calculating the Sort Order Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!