Download the featured file here: https://www.bluepecantraining.com/create-a-multi-column-non-contiguous-return-array-using-xlookup/

In this video I demonstrate how to create a non-contiguous return array when using XLOOKUP to return multiple columns of data.
------------------------