Excel Snippets: VLOOKUP and XLOOKUP Functions

I might not post many Excel snippets, but I’m collecting them into a small series to make them easy to find. VLOOKUP has long been one of the most-used functions in Excel, but it has a number of limitations that XLOOKUP, introduced in Microsoft 365, was designed to fix. If you are starting out fresh...

Read original post Excel Snippets: VLOOKUP and XLOOKUP Functions at azurecurve|Ramblings of an IT Professional