🔥 500,000+ professionals trust our courses—start your journey here! 👉 https://link.xelplus.com/yt-g-shorts-all-courses In this video, we’ll set up the FILTER function with two criteria in different columns. Both of these conditions have to be met (AND) for the result to be included. If you're searching for how to FILTER your data with multiple criteria, this video has the answer. If you need OR criteria, for example looking up two different values within the same column, you'll need to use the PLUS operator. 🌍 My Online Excel Courses ► https://www.xelplus.com/courses/ 🎬 LINK to more YouTube Shorts videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/ 🎥 GEAR I use: https://www.xelplus.com/resources/#gear More resources on my Amazon page: https://www.amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani 👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel