XLOOKUP with Multiple Criteria | Advanced Excel Trick | GunjanShares

Показать описание

Hello Friends,
You can use XLOOKUP function to return value based on multiple lookup criteria. In video, I have shown you the trick which you can use to perform this.

XLOOKUP is surely the new excel SUPERHERO 🦸‍♂️

in this video:
00:00 - Introduction
00:39 - XLOOKUP explained
01:08 - XLOOKUP with 2 lookup criteria
03:28 - XLOOKUP with 3 lookup criteria
04:34 - XLOOOKUP with two-way lookup
06:32 - Ending Remarks

This video will answer below questions:
- How to use XLOOKUP in excel
- XLOOKUP function in excel
- Advanced uses of XLOOKUP
- Advanced Excel Tips
- Excel 365 Tricks

You must check out this video to know more about XLOOKUP function:

The entire excel productivity playlist:

---------------------------------------------------------------------------
Gears I Use:

---------------------------------------------------------------------------
If you liked this video, please hit the Like button, share it with your friends and share your views in the comments, and subscribe to the channel.
---------------------------------------------------------------------------
Follow #gunjanshares