Blog Post

Excel Blog
3 MIN READ

Announcing XLOOKUP

JoeMcDaid's avatar
JoeMcDaid
Icon for Microsoft rankMicrosoft
Aug 28, 2019
March 31st Update XLOOKUP is now available to all Office 365 Subscribers in the Monthly Channel and will be available to users in the Semi-Annual Channel starting in July. It will be available to u...
Updated Jun 25, 2021
Version 17.0
blog
excel
Aurelie_Silvrants's avatar
Aurelie_Silvrants
Copper Contributor
Feb 24, 2022

Hi all,

 

I am also very excited about the XLOOKUP Function, here in Belgium it is nog communly used yet I have the impression.

However since I have been using it instead of VLOOKUP I am having trouble with my Excel files. I keep getting

"Calculating (8Threads):xx%"

Somethimes it dissapears after a few seconds however in somethimes it can take hours... or just block.

It is the biggest issue offcourse when the files are large however also small files have the same issue.

And if I replace the Xlookup by the old Vlookups the issue seems to dissapear...

Did anyone have the same issue? Is there a way to solve it?

 

I really love using it so would be very dissapointed if I would have to go back to Vlookup because of this 🙂

 

Thank you!

Regards

Aurélie