by Crispo Mwangi | May 25, 2020 | INTERMEDIATE EXCEL
This post is inspired by Dave Bruns’s post on Two-way approximate match multiple criteria. Having read Dave’s article I thought… “Is there an easy way of doing this using XLOOKUP instead of INDEX/MATCH?” 🤔 Option 1: Using IF Function...
by Crispo Mwangi | May 14, 2020 | ADVANCED EXCEL
NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction of the XLOOKUP FUNCTION. Excel experts called it “Functions Killer”, “Ultimate Lookup Function”, “Single Most Important function”,...
Recent Comments