Move over VLOOKUP, here comes XLOOKUP

XLOOKUP Excel 365 (insider edition) VLOOKUP is one of those functions’ users tend to use over and over.  At the start it is hard to get your head around it but once you do, it provides great value. However, it also has its limitations. For example, on its own it cannot look up to the […]


XLOOKUP V’s VLOOKUP – 8 Limitations Removed

XLOOKUP V’s VLOOKUP XLOOKUP, soon to be available in Excel 365 is going to make you rethink how you carry out your lookups. VLOOKUP comes with many limitations. Some of these limitations we can work around with other functions or combination of functions. But that is a pain…and time-consuming. Who needs all that hassle when […]