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)
------------------------