News
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.
If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results