While everyone is super exciting about the XLOOKUP function, I would like to suggest a minor thing that is very basic but super helpful to most all Excel users.
My humble suggestion:
Adding a button for number formats in thousand/million/billion
Why have I come up with this idea?
Long time ago, I wrote a post Show number in thousand (k) or in million (M) by using custom format, which to my surprise, have become one of the top 3 posts in my blog. It reflects the truth that it is a very common demand from Excel users. Although it is not really “difficult” to use the custom format to solve the problem, it is not obvious nor intuitive for sure.
Then I searched the UserVoice to see if anyone has the same idea. Of course, there is. I came across the idea submitted HERE. I VOTED for that immediately and left my additional suggestions in comments. However, the number of VOTE is surprisingly low (only 28 votes including mine).
So, if you like the idea, may I ask you to VOTE for it! And more importantly, spread the word to invite more votes. Every VOTE counts. Sometimes, a tiny change would make a big difference. 🙂