Forum Discussion

droberson314's avatar
droberson314
Copper Contributor
Jan 08, 2021

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/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

 

excel
Excel on Mac
Formulas and Functions
office 365

2 Replies

  • Rich99's avatar
    Rich99
    Iron Contributor
    Jan 23, 2021
    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

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 08, 2021

    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.

Resources