Forum Discussion
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 dat...
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.
Thank You! It appears to be working. I appreciate you taking the time.
Hi Hans, Hope you are well today. I had some spreadsheets work and others not using old formulas and new one you provided and inconsistencies within the same spreadsheet. If you have time can you please take a look at 4 spreadsheets and see if you can help. Thanks so much.
Nicole