Building a Lookup Returning Multiple Values with LAMBDA 

This video will explain how to build a LAMBDA function in Excel to develop a function like XLOOKUP that returns multiple values instead of a single value.
This builds on the earlier video where this function was built without using a LAMBDA function:
• Multiple Values - One ...
The Advanced Formula environment (in Excel Labs) is strongly recommended in order to follow along with this video.

Наука