XLOOKUP Spilling Secret: How to fix the array of arrays problem!

Video Description

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-signup/ File Reference for this video: 0236 XLOOKUP spilling - array of arrays.zip ★ About this video ★ With XLOOKUP we can spill by providing multiple columns/rows in the return_array or multiple values in the lookup_array. But if we try to use both of these at the same time, Excel doesn't calculate as we expect. It causes the array of array problem. What is this problem, and how can we solve it... let's find out. 0:00 Introduction 0:24 What causes the array of arrays problem 2:24 Solution 1: REDUCE/LAMBDA Combo 4:28 Solution 2: CHOOSEROWS/XMATCH Combo 5:57 Wrap-up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel