Learn Excel XLOOKUP Inside Out - 8: Return Array of Multiple Values

Learn Excel XLOOKUP function inside out from this series of training videos. You will learn from the basic and simple form of XLOOKUP, all the way to the advanced usages of XLOOKUP function.
The XLOOKUP Inside Out series contains below lessons:
1: Vertical Lookup • Learn Excel XLOOKUP In...
2: Horizontal Lookup • Learn Excel XLOOKUP In...
3: Match Not Found • Learn Excel XLOOKUP In...
4: Partial Match • Learn Excel XLOOKUP In...
5: Lookup from Last to First • Learn Excel XLOOKUP In...
6: Match Next Smaller • Learn Excel XLOOKUP In...
7: Match Next Larger • Learn Excel XLOOKUP In...
8: Return Array of Multiple Values • Learn Excel XLOOKUP In...
9: Two-Dimensional Lookup • Learn Excel XLOOKUP In...
10: Lookup Multiple Fields • Learn Excel XLOOKUP In...
11: Return Multiple Matches by FILTER • Learn Excel XLOOKUP In...
12: Lookup Text as Number • Learn Excel XLOOKUP In...
13: Lookup Number as Text • Learn Excel XLOOKUP In...
14: Lookup Both Text & Number • Learn Excel XLOOKUP In...
15: Lookup Picture & Return Pictures • Learn Excel XLOOKUP In...
16: Lookup from Multiple Sheets • Learn Excel XLOOKUP In...
Please use this link to access the accompanying training Excel files to practice along: www.superexcel...

[@SaintPalencia]

Great video! It's a shame you can't use the array principle to populate both the columns and rows, but alas perhaps maybe a ZLOOKUP in the future will have this functionality!

[@SuperExcel.online]

That would be cool!

[@SuperExcel.online]

Thanks. I really like your way of thinking. I think that’s why human are always improving, by thinking and expecting what we would like to see. I’m all for the ZLOOKUP👍! I’m sure XLOOKUP came about due to Excel users’ feedback of VLOOKUP’s limitation.

[@ganpot6429]

Thanks!

[@AccroExcel]

thanks