Thanks to the newish dynamic array function XLOOKUP(), you now have more power and less confusion. In this article, we’ll compare XLOOKUP() to VLOOKUP() so you can see how XLOOKUP() excels and ...

FILTER() is one of Microsoft 365’s new dynamic array functions. ... In addition, you can filter by a single column or several. Now, let’s put the FILTER() function to work.