Excel Tutorial Interview Series: Part III. Today, we will work with an interview example about how to pull data from a different sheet with Xlookup and Maxifs with multiple criteria. 📚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[Likes], "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 result in a 1 Table3[Likes], When all three conditions equal 1, return the Likes value from that row. "Not Found") If no row meets all conditions, return “Not Found”. 💬 Let me know in the comments section if it worked for you 💚 Level up your Excel game and your career. Hit the plus for weekly tutorials #interviewquestions #excelfunctions #dataanalyst