I own a copy of Widows 11. That of course includes Excel and I use it a lot to help others with VBA code. What version of Excel do I need to purchase in order to be able to deal with things like XLookup which my current Excel doesn't support?
Printable View
I own a copy of Widows 11. That of course includes Excel and I use it a lot to help others with VBA code. What version of Excel do I need to purchase in order to be able to deal with things like XLookup which my current Excel doesn't support?
I do not like Office 365 since it sucks money out of your wallet every time you type an "A" into Word or a "1" into Excel, and it is always auto-updating itself and removing features you use while adding some bling-bling and eye-candy that you will never use.
Office 2021 should have the Excel XLookup function. I have seen rumors that Office 2019 does also, but if you are buying a perpetual license version you might as well get the 2021 version.
https://www.quora.com/How-do-I-add-i...on-in-MS-Excel
https://techcommunity.microsoft.com/...ersion/4042537
Thanks.