Month: November 2020
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. The CHOOSE function does the trick here as you will see in the formula below. I created an array of index numbers {1,2,3} which correspond to the columns I have selected in the value 1, value 2 and value 3…
Read More