XLOOKUP Retires VLOOKUP and More
Channel: dbrownconsulting
Date: 2020-02-06

XLOOKUP retires VLOOKUP and More. Learn about the new XLOOKUP from Excel and it's functions. Watch the video to learn how to use it and useful tips.

Table of Content
1 DEMO 00:02:26;17
2 XLOOKUP EXACT MATCH HIGHLIGHTS 00:22:50;06
3 XLOOKUP APPROXIMATE MATCH HIGHLIGHTS 00:25:12;13
4 XLOOKUP LAST MATCH QUICK HIGHLIGHTS 00:26:35;19
5 XLOOKUP WITH DYNAMIC ARRAYS HIGHLIGHTS 00:28:16;10
6 DYNAMIC TABLE EXTRACTION METHODOLOGY 00:30:14;06
7 BUILDING A DYNAMIC TABLE TEMPLATE 00:34:41;10
8 ADVANCED XLOOKUP TO QUERY DATA 00:39:55;15
9 FINALISE YOUR MINI REPORT 00:43:39;01
10 END 00:45;14;23

Subscribe to our Channel
Our videos contain tips, tricks, best practices and methodologies for working with Data and improving your productivity at work using these tools: Microsoft Excel, Financial Modelling, Power BI, DAX, Power Query, M, Accounting, Finance, PowerPoint, Word, Office365, Azure Technologies.

Please visit our websites and resources below for even more freebies and information
Corporate Training: http://dbrownconsulting.net/
Online Training: http://www.officetraininghub.com/
Excel & Power BI Meetup: https://www.meetup.com/Nigeria-Excel-Power-BI-User-Group/
Financial Modeling Meetup: https://www.meetup.com/FinancialModeling
Power Bi USerGroup: https://www.pbiusergroup.com/lagos