Uploaded September 2026 | Updated November 2026, 3 hours ago
👩🏻🎓Do you want to learn Pro-Level Excel techniques or Power BI?
Check out our amazing course at accessanalytic.thinkific.com
Micrisoft docs:
techcommunity.microsoft.com/blog/microsoft365insiderblog/put-multiple-values-in-one-cell-with-lists-and-arrays-in-excel/4559395
📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/
The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
00:00 Introduction
00:18 Why XLOOKUP Arrays Were Previously a Problem
01:18 XLOOKUP Now Returns In-Cell Lists
01:58 Using the New FLATTEN Function
02:14 Introducing the HAS Function
03:38 HAS, HASANY and HASALL Explained
05:31 What Are Excel Lists?
06:49 Filtering Individual Items Inside Lists
08:07 Referencing List Items with INDEX
08:44 When Lists Are Useful (and When They're Not)
09:17 Final Thoughts on FLATTEN and HAS Functions
👩🏻🎓Do you want to learn Pro-Level Excel techniques or Power BI?
Check out our amazing course at accessanalytic.thinkific.com
Micrisoft docs:
techcommunity.microsoft.com/blog/microsoft365insiderblog/put-multiple-values-in-one-cell-with-lists-and-arrays-in-excel/4559395
📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/
The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
00:00 Introduction
00:18 Why XLOOKUP Arrays Were Previously a Problem
01:18 XLOOKUP Now Returns In-Cell Lists
01:58 Using the New FLATTEN Function
02:14 Introducing the HAS Function
03:38 HAS, HASANY and HASALL Explained
05:31 What Are Excel Lists?
06:49 Filtering Individual Items Inside Lists
08:07 Referencing List Items with INDEX
08:44 When Lists Are Useful (and When They're Not)
09:17 Final Thoughts on FLATTEN and HAS Functions










![How to get 6 million views on YouTube [satire]
🫶🏻 Join the channel to get access to perks:
https://www.youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🧑🏻🎓Learning Power BI?
Check out our online course
https://accessanalytic.thinkific.com/
📗 Did you know Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/ How to get 6 million views on YouTube [satire]](https://i.ytimg.com/vi/7y3N5EzP9kw/mqdefault.jpg)