When people ask me what my favorite software of all time is, my answer is always Microsoft Excel. True, I am a proponent of both Linux and LibreOffice, but the fact is, nothing compares to Microsoft Office. If I have to do some serious data analysis and need to work with spreadsheets, I want real Excel. Can I get by with LibreOffice Calc? I mean, yes, but I’d rather not.
When looking to tell stories with data, I often turn to the VLOOKUP function — one of the most important and powerful tools found in Microsoft Excel. Believe it or not, VLOOKUP may be on its way to extinction, thanks to the release of XLOOKUP, which is basically VLOOKUP on steroids. While Office Insiders have been able to play with this new function, beginning today, it is finally available to all.
The highly anticipated XLOOKUP function in Excel is generally available for all users across Windows, Mac, and Excel on the web. XLOOKUP is the successor to the iconic VLOOKUP function, which has been one of the most used functions in Excel. XLOOKUP helps users find what they need more efficiently with fewer limitations, from being able to look up a value vertically and horizontally (and to the left!) to supporting column insertions and deletions and more,” says The Excel team.