XLOOKUP from BASIC to ADVANCED using MULTIPLE CRITERIA for  

Ever need to find just the right value in your #Excel or #googlesheets, but not sure how to get it without a lot of filtering and sorting?
In this #exceltutorial we're going to look at one of the most powerful formulas, #XLOOKUP.
We'll cover the basics on how to use it and move into a more advanced situation where we use XLOOKUP to search using multiple criteria by understanding the boolean values behind TRUE and FALSE.
Video Chapters
============================================
00:00 - Introduction
00:50 - XLOOKUP Basics
03:49 - Understanding Booleans
06:39 - XLOOKUP with MULTIPLE CRITERIA
09:37 - Thanks!

Наука