Easy XLOOKUP Hacks You Need To Try in Excel!

We always lookup 1.

~

XLOOKUP is one of the most powerful and useful XL functions ever. In this video, learn how to take your XLOOKUP skills to next level and impress everyone with a sneaky little trick, by looking up 1.

Topics covered:
✔️ How to do multi-criteria lookups
✔️ Boolean arithmetic - the powerful of 1s & 0s
✔️ Advanced AND criteria
✔️ Advanced OR criteria with xlookup
✔️ How to see all matching values? FILTER(1) trick!

📁Sample file - https://chandoo.org/wp/wp-content/upl...

📺More on XLOOKUP

XLOOKUP in SIX (6) Minutes -    • XLOOKUP Excel Function - Made Easy for Beg...  
I stopped using VLOOKUP -    • I don't use VLOOKUP anymore. I use this in...  
XLOOKUP - 10 Advanced Tricks -    • 10 Advanced XLOOKUP Tips & Tricks  

🧑‍💻 Complete Advance Excel Course:

Learn Advanced Excel and become awesome at work. Join my Excel School program today and master vital spreadsheet skills - right from Power Query to Dashboards. Everything in one place with 50+ practice files, 30 hours of video content and 100+ lessons.
Join here - https://chandoo.org/wp/excel-school-p...

~

#xlookup #excel