Forum Discussion

Copper Contributor

Oct 28, 2020

Excel on Windows PC to Macbook

Hi there, Wondering if anyone would know or have any advice for me. I am working with a nutritionist who has formulated an excel spreadsheet counting calories for me. She is working on a Wind...

excel

Excel on Mac

Formulas and Functions

office 365

NakitaO_

Copper Contributor

Nov 03, 2020

Riny_van_Eekelen

Thanks so much for your reply.

Below is how the formula it is supposed to be and how it is on the Windows OS as well as what it looks like when I open it... does this make any sense to you? Do you think it's a more modern version? Because it doesn't work when I open it on my MacBook...

MacBook: =C9+_xlfn.XLOOKUP(Female!C12;'drop down'!B2:B7;'drop down'!C2:C7)

{do you know what that _xlfn. Is?}

Windows (how it should be): =C9+XLOOKUP(Female!C12,'drop down'!B2:B7,'drop down'!C2:C7)

Riny_van_Eekelen

Platinum Contributor

Nov 03, 2020

NakitaO_ Thanks for the clarification. Your Excel for Mac version does not support the XLOOKUP function. Hence, the "_xlfn" addition to the formula. Ask your nutritionist to rewrite the formulae without XLOOKUP or do it yourself. Without being able to test it, that could be:

=C9+VLOOKUP(Female!C12,'drop down'!B2:C7,2,FALSE)

Here you can read more about XLOOKUP and which Excel versions support it.

https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929