Jun 19 2024 10:30 AM - edited Jun 19 2024 10:48 PM
XLOOKUP is available only in certain versions of Excel. Here are the steps to ensure you have access to XLOOKUP:
Ensure You Have the Right Version of Excel
XLOOKUP is available in:
If you have an older version of Excel (such as Excel 2016 or earlier), XLOOKUP will not be available.
To access XLOOKUP, you may need to upgrade to a version that supports it.
Happy Excel-ing!
Jun 19 2024 10:47 PM
Thanks for the information, I have the same link in my message but I didn't really look it up .
Until now I had it in my head that it was also possible in Excel 2019, but now I've been proven wrong .
Thanks again for the correction.
Jun 20 2024 08:09 AM
I was surprized it shall to work in 2019 if someone else creates the file. But didn't test.