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. I agree on feedback where Child ASINS do not exist, but for example. ASIN BO7JRBRNFW (Sheet 1, column A2) does exist in Sheet 3 but there is no run rate calculating in Column G2. In terms of IFERROR, my boss asked me to remove. Go figure!
Strange: I get 1,71 in G2 (Excel Online uses comma as decimal separator in my country)...