Hi all,
Happy Friday!
Last week I shared an article on the pros and cons of XLOOKUP vs VLOOKUP. You can find that article here:
XLOOKUP vs VLOOKUP.
This week, I wrote about XLOOKUP vs INDEX and MATCH:
[
Read the full article]
XLOOKUP brings a ton of power and flexibility to the table. But INDEX and MATCH have always been a go-to solution for difficult lookup problems in Excel. Plus, the new XMATCH function gives this classic combo many new features.
The verdict? It's close! Read the article for a detailed comparison.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
