In this video I demonstrate how to use XLOOKUP to lookup across two worksheets. I explain two methods you can use to achieve this.
Table of Contents:
00:00 - XLOOKUP between two worksheets
03:34 - XLOOKUP between two worksheets using Excel tables (dynamic range)
------------------------
- How to Use XLOOKUP Across Two Worksheets | XLOOKUP Examples Across Two Sheets ( Download)
- How to Do a VLOOKUP With Two Spreadsheets in Excel ( Download)
- How to XLOOKUP from Another Worksheet (Sheet) in Excel ( Download)
- The Ultimate XLOOKUP Tutorial (The Best Excel Formula) ( Download)
- How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP ( Download)
- Excel xlookup - How to use the Xlookup function to lookup information in a different sheet tutorial ( Download)
- Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel ( Download)
- How to use VLOOKUP & XLOOKUP in excel multiple sheets ( Download)
- Xlookup Across Multiple Tabs in Excel ( Download)
- XLOOKUP with Multiple Conditions ( Download)
- The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more) ( Download)
- Lookup in Multiple Sheets at the Same Time (VLOOKUP & XLOOKUP) ( Download)
- Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP ( Download)
- How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples) ( Download)
- XLOOKUP in Excel Tutorial ( Download)
