XLOOKUP is a new function Microsoft has begun to integrate into their 365 subscription platform. This function looks to replace the likes of VLOOKUP and the INDEX/MATCH format. How does it hold up in comparison? Is it worth upgrading to Microsoft365? Download a free Excel workbook to test out the differences between all three functions!
Read More