If you’d like to learn about XLOOKUP (), read How to use the newish XLOOKUP () dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.

Now, let’s put the FILTER () function to work. How to use the FILTER () function in Excel Using FILTER () has one requirement: You must use the same headers in the filtered set range.