Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial

The XLOOKUP function in Excel allows you to perform a two-way lookup. The XLOOKUP function came out in 2019 and provides much more versatility than VLOOKUP and HLOOKUP. The XLOOKUP function will look up values LEFT, RIGHT, VERTICALLY, and HORIZONTALLY, it returns results based on multiple criteria, it performs an exact match by default, and finally, XLOOKUP will look from last to first.

The key to creating a two-way lookup is to use nested XLOOKUP functions in a single statement or formula. In this video, I demonstrate how to do that by creating a two-way lookup across Q1, Q2, Q3, Q4, and also a number of employees to retrieve values in a bi-dimensional table... effectively creating a double XLOOKUP.

XLOOKUP is much easier to explain, as a trainer, than VLOOKUP, and it's straightforward to demonstrate what it does and to verify if the values you're obtaining are correct.

More relevant XLOOKUP videos:

XLOOKUP presentation:
   • XLOOKUP - Excel's new awesome functio...  

XLOOKUP vs VLOOKUP:
   • XLOOKUP vs VLOOKUP & MATCH by Chris M...  

Index & Match vs XLOOKUP:
   • Vlookup vs Index and Match in Excel b...  

More Microsoft Excel Videos:
   • Microsoft Excel Videos  

Visit my Microsoft Excel Blog:
https://chrismenardtraining.com/train...

#xlookup #excel #exceltutorial

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!