XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611

Download Excel File: https://ift.tt/2IFd37a
Learn about how to use XLOOKUP or VLOOKUP to lookup a rectangular range of lookup values and return a rectangular range of returns values.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.