By Andrew Gould

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-xlookup/

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:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

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!