Excel xlookup - How to use the Xlookup function to lookup information in a different sheet tutorial

Excel xlookup - How to use the Xlookup function to lookup information in a different sheet tutorial

Sample files can be found here:
https://www.dropbox.com/sh/zgcw7ss4ar...
Please subscribe to my channel
http://www.youtube.com/user/TomFragal...
For Full versions of these videos, or to join my mailing list:
http://www.pcwebinars.com

Tom Fragale
Microsoft Certified Trainer
Microsoft Certified Office Master
Available for Onsite Training, Private Webinars, Consulting, and Custom Software
(215)280-1073
[email protected]

To get the sample file from these videos, send an email to
[email protected]


Top 20 Most popular videos

Create Mailing Labels from Your Excel 2010 data using Mail Merge in Word 2010 Christmas holiday 2016
   • Create Mailing Labels from Your Excel...  
Using Excel Macros and VBA - Complete - Excel VBA 2010 2013 2007 2016 Tutorial Macros & Visual Basic
   • Using Excel Macros and VBA - Complete...  
Using An Excel If Function Formula With Multiple Conditions - Excel 2010 Tutorial Examples 2013 2016
   • Using An Excel If Function Formula Wi...  
How To Compare 2 Sheets Using The Excel Vlookup Function Formula 2007, 2010 , 2013, 2016 Tutorial
   • How To Compare 2 Sheets Using The Exc...  
Excel Pivot Table Tutorial - Create A Monthly, quarterly, Yearly Summary Report Excel 2013 2016 2010
   • Excel Pivot Table Tutorial - Create A...  
Creating a workflow in Sharepoint 2013 - How to create a workflow in Microsoft Sharepoint 2013 2016
   • Creating a workflow in Sharepoint 201...  
How to compare 2 tables in Access - Create a Find Unmatched Query in Access 2007 2010 2013 2016
   • How to compare 2 tables in Access - C...  
Access switchboard manager - creating a main menu in Access 2010 Tutorial Access 2013 2007 2016
   • Access switchboard manager - creating...  
Linking Sheets - Linking Data from Different Excel Sheets and Workbooks - 2010 Tutorial 2013 2016
   • Linking Sheets - Linking Data from Di...  
Installing an odbc driver in Windows 10 - SQL Server ODBC Driver Excel 2013 2016 Microsoft Access
   • Installing an odbc driver in Windows ...  
Installing an odbc driver in Windows 8 and Windows 8.1 and Windows 10 SQL Server ODBC Driver Excel
   • Installing an odbc driver in Windows ...  
How to reset autonumber in Access 2013, Microsoft Access 2010, and Access 2007 Access 2016
   • How to reset autonumber in Access 201...  
How to add a great lookup field to An Access form using the combo box wizard. Access 2016 2013 2010
   • How to add a great lookup field to An...  
How to make an Access query using yes no fields - Access 2010 Tutorial Access 2013 Access 2007 2016
   • How to make an Access query using yes...  
Word Basics - Tutorial for Beginners - Microsoft Word 2010, 2013, 2016 Office 365 Getting Started
   • Word Basics - Word Tutorial for Begin...  
Word - Adding a Picture To Mailing Labels - Create Christmas Holiday Labels Mail Merge 2010 2013
   • Word  Adding a Picture To Mailing Lab...  
How to lock a field on an Access form field protection on a form Microsoft 2007 2010 2013 2016
   • How to lock a field on an Access form...  
How to Use a sharepoint list in Access 2013, Microsoft Access 2010, and Access 2007 Tutorial
   • How to Use a sharepoint list in Acces...  
Excel Pivot Tables, Pivot Charts, Slicers and Dashboards - Complete Excel 2010 2013 2016 Tutorial
   • Excel Pivot Tables, Pivot Charts, Sli...  
How to import a text file into Access - Access 2010 tutorial CSV file Access 2007 Access 2013 2016
   • How to import a text file into Access...  

Most recent videos
Excel 2016 PowerPivot and PowerQuery , Measures and KPI Data Analysis Excel PowerPivot & PowerQuery
   • Excel 2016 PowerPivot and PowerQuery ...  
Excel Database Part 1 - How to Use Excel as a database - Excel 2010, 2013, 2016 tutorial
   • Excel Database Part 1 - How to Use Ex...  
Excel Database Part 2 - How to Use Excel as a database - Excel 2010, 2013, 2016 tutorial
   • Excel Database Part 2 -  How to Use E...  
Installing SQL Server on Windows 10 - How to install SQL Server 2016 Express on Windows 10 Free SQL
   • Installing SQL Server on Windows 10 -...  
Excel For Bankers - How to maximize using Microsoft Excel For Bankers - Excel 2010, Excel 2013,
   • Excel For Bankers - How to maximize u...  
How to Export from an Access Table or Query to SQL Server - Access 2010, Access 2013, Access 2016,
   • How to Export from an Access Table or...  
How to create an ODBC Driver in Windows 10 for SQL Server 2016 - Tutorial
   • How to create an ODBC Driver in Windo...  
Making it so it is required to check out a document in a document library in SharePoint 2016 & 2013
   • Making it so it is required to check ...  
Displaying multiple windows in Windows 10 - How to display multiple windows in Windows 10, Windows 8
   • Displaying multiple windows in Window...  
How to Create Rules in Outlook to automatically handle emails - Outlook Rules tutorial - 2016, 2013
   • How to Create Rules in Outlook to aut...