Скачать с ютуб How to Solve Complex Lookup Problems in Excel with TEXTJOIN в хорошем качестве

How to Solve Complex Lookup Problems in Excel with TEXTJOIN

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... Watch this video to find out how to get multiple lookup results in Excel. We'll cover a complex LOOKUP problem – the task is to find the header of the lookup criteria, which is in a matrix. ⬇️ Download the workbook here: https://pages.xelplus.com/textjoin-lo... This example builds on the example shown in the previous videos which has a matrix of apps which belong to different divisions. The apps are the values inside the matrix and the divisions are the headers. The aim is to find the header value based on the matrix value. Since the data in this example is not unique and an app can belong to more than one division, the aim is to come up with a formula that finds all the divisions one app could belong to. Excel's TEXTJOIN function is a great solution to this problem. On top, when combined with the FIND & IISNUMBER function, it can help us avoid duplicate results. Watch this video as I take you through Bill's formula solution. ✔ Alternate Solutions ✔ My version with Index & Sumproduct:    • Excel Complex Lookup: Find Header bas...   My with Index & Aggregate:    • Excel Formula Lookup Multiple Results...   Watch Kevin's video to see 4 different approaches of solving this 2 with array formulas, 1 with helper columns and last one with a pivot table to normalize the date set:    • 00165 Show Col Header for Matrix Valu...   Watch Oz's Video from Excel on Fire here which shows how to solve this with a COUNTIFS function and the Power Query method:    • Retrieve The Correct Column Header (L...   ★ My Online Excel Courses ► https://www.xelplus.com/courses/ ➡️ Join this channel to get access to perks:    / @leilagharani   👕☕ 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/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram:   / lgharani   LinkedIn:   / xelplus   Note: 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