How To Use XLOOKUP With Multiple Criteria

Unlock the true power of the XLOOKUP function by being able to create lookups with Multiple Criteria. Excel's XLOOKUP function is the newer and better version of the VLOOKUP function, but when you have two or more criteria as your lookup values, it can be problematic to understand how to retrieve the answer you need.

Are you ready to master the XLOOKUP function? This tutorial provides you TWO methods in working around this problem.

Don't forget to give this video a thumbs up if you found it helpful, and consider subscribing to my channel for more Excel tips, tricks, and tutorials. Your support keeps me motivated to bring you valuable content that simplifies your data tasks.

00:00 Introduction
00:28 With Helper Column
02:18 Without Helper Column
03:38 Deeper Dive
05:17 Wrap Up

👍 Learning key skills in Excel are essential to becoming the data analysis expert in your organisation, so remember to like, share, and subscribe to my channel for more Excel training videos and get ready to take your Excel skills to the next level!

Connect with me on my socials:

[How__Excel]

Here is the link to the file if you want to follow along.

[mohammadzeeshan]

The second method is very impressive and logical.

[manjit.sarania]

Sir ur teaching is great but data and formula is not seen clearly to learn