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/uploads/2025/07/xlookup-multiple-criteria.xlsx 📺More on XLOOKUP XLOOKUP in SIX (6) Minutes - https://youtu.be/dlBuWllegRg I stopped using VLOOKUP - https://youtu.be/DDlZXXEI1bU XLOOKUP - 10 Advanced Tricks - https://youtu.be/YyhJe5tMq58 🧑‍💻 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-program/ ~ #xlookup #excel