Excel Tutorial Interview Series: Part IV. Today, we will work through an interview example on how to pull data from a different sheet using XLOOKUP and MAXIFS with multiple criteria. This time, we will return the last video views, taking into account criteria such as influencer name, date, and channel. 📚Excel Formulas Clean Names → =TRIM(PROPER([@Entity])) Likes Formula → =XLOOKUP( 1, (Table3[Date]=MAXIFS(Table3[Date], Table3[Helper Entity], [ @Influencers], Table3[Helper Medium], "Youtube")) * (Table3[Helper Entity]=[ @Influencers]) * (Table3[Helper Medium]="Youtube"), Table3[Views], "Not Found") ✨Formula explained =XLOOKUP( 1, → when we multiply our conditions together, the result is only 1 when all conditions are true (Table3[Date] =MAXIFS(...)→ Condition 1: Match the latest date for this influencer on YouTube. MAXIFS Breakdown Look at the Date column to find the most recent date, But only for rows where Entity = current influencer, And Medium = “YouTube”. 👉 This returns the latest YouTube upload date for that influencer. (Table3[Helper Entity] = [ @Influencers])* Condition 2: Entity must match the current influencer. (Table3[Helper Medium] = "Youtube"),* Condition 3: Medium must be YouTube. 👉 Multiply all the conditions and retrieve only rows where ALL THREE conditions are TRUE, resulting in a 1 Table3[Views], When all three conditions equal 1, return the View value from that row. "Not Found") If no row meets all conditions, return “Not Found”. 💚 Level up your Excel game and your career. Hit the plus for weekly tutorials #interviewtips #microsoftexcel #exceltutorial