Performance of XLOOKUP: How fast is the new XLOOKUP vs. VLOOKUP?

We’ve explored the basics of XLOOKUP, discovered a wide range of advanced use cases for XLOOKUP and the advantages towards VLOOKUP and INDEX/MATCH. What we have not talked about so far is the performance of XLOOKUP. Especially for larger Excel models with possibly hundreds of thousands of functions to calculate, performance is a major concern.… Continue reading Performance of XLOOKUP: How fast is the new XLOOKUP vs. VLOOKUP?

Study: What Really Helps to Reduce the File Size of Your Excel Workbook

You have just finished your work and want to send your file to your boss. He is waiting for it. But instead of sending the email, you just receive and error: The file size is too large. This is the moment you tell yourself not to panic. And actually there is no reason to panic.… Continue reading Study: What Really Helps to Reduce the File Size of Your Excel Workbook

Before you leave: Boost your Excel skills!Join thousands of Excel users & subscribe to the newsletter!
  • The best Excel tips, tricks and tutorials.
  • 1x per month.
  • No spam. Promised.
Welcome gift: Save a lot of time with my huge keyboard shortcut package.

Learn more