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!

[@jsphpalumbo]

How many of you have already switched from INDEX+MATCH to XLOOKUP? Would love to know which method you prefer?

[@Sachin-sw6om]

Hello, I have a add on installed in google sheet (when I fill the data in google sheet it triggers a data to add on app) . The problem is when I get the data in google sheet from google forms, it is not triggering data to add on . Pls give me solution. I have tried the spreadsheet.flush option, it’s not working