Forum Discussion

Nicole1243's avatar
Nicole1243
Copper Contributor
Aug 06, 2021
Solved

Excel formulas not working from PC to MAC

Hi, My boss developed an inventory spreadsheet for me to populate with data. She inputed the formulas as well. She uses a PC and I use a MAC.  The formulas are not working for me when I input the data, I am getting #NAME errors but when I email the populated reports back to her, the formulas are working on her computer.  Please help.  I can not do my job at this point.  I already went to help and ensured the data was in GENERAL and not TEXT. I also checked that the formulas are automatically updating. I attached the spreadsheet so you can directly review. Thank you!

  • Nicole1243 

    Thanks. the workbook uses the XLOOKUP function that is only available in Excel in recent versions of Microsoft 365. On a Mac or PC with Excel 2019 or earlier, XLOOKUP does not exist, so the formulas return #NAME!

     

    In the attached version, I have replaced the XLOOKUP formulas with a version that uses VLOOKUP. That should work in all versions of Excel.

17 Replies

Resources