To use the XLOOKUP function to return values from non-adjacent columns or rows, you need to nest the FILTER function in the return array argument, with 0s and 1s in curly braces telling Excel ...

Unfortunately, if you're using Excel 2019 or earlier, you won't be able to create your own functions using the methods described in this guide.

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.