Forum Discussion

NakitaO_'s avatar
NakitaO_
Copper Contributor
Oct 29, 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
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 29, 2020

NakitaO_ 

If your nutritionist is on a more modern version it could be that she uses functions that are not supported by yours. This will show as errors on your side.

If you are using different language versions, the formulae will look different for both, but they will still work as intended. 

 

If this does not explain your situation, please give some explanation of how formulae change. What has your nutritionist typed and what do see on your end.

NakitaO_'s avatar
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)

Resources