Adding "Paste Value" in Excel 2019

[droberson314]

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/20/excel-paste-special-shortcuts-features/) using "Paste Value" may work just to get the results of the function from Excel 365 to Excel 2019, but I am not seeing that as an option (see screenshots). 

Is there a way to add it in or where can I find it in Excel 2019?

12

[#2]

@droberson314 

Paste Values works only when you copy and paste within the same instance of Excel.

When you copy cells in Excel 365, then switch to Excel 2019, the latter treats the clipboard data as data from another application, so Paste Values is not available.

I'd copy/paste values within Excel 365, then save the workbook under another name, and open the new workbook in Excel 2019.

[#3]

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