Forum Discussion
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!
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
You didn't attach anything...
- Nicole1243Copper Contributor
Hi Hans,
Sorry to bother you again with my excel issues. My boss had me upgrade microsoft/excel on my computer with the most current versions to address XLOOKUP formula issues. I thought running the reports today would have been simple. Instead I am running into formula challenges again but they are not consistent. On some of the reports they work 100% of the time, other reports some of the time and then none and I am using the same template! Can you please take a look at the attachments when you have a chance. Thank you. Nicole
I'm confused - why did you post 3 replies with attachments?
And where exactly is the problem?
- Nicole1243Copper Contributor
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.