Forum Discussion
Adding "Paste Value" in Excel 2019
I am trying to copy a worksheet containing the =XLOOKUP function from Excel 365 into Excel 2019 (which apparently doesn't translate). I read (https://www.ablebits.com/office-addins-blog/2016/10/2...
Office 2019 does not support the XLOOKUP function that is used in Office 365, you will need to revert to VLOOKUP, HLOOKUP or INDEX functions instead.
Rich
Rich