Windows 10: My Excel version are "Microsoft Office Home and Student 2019", however formula like xlookup...

It work at first when I write it, and it appear #NAME? on the next day I open my file.All my formula included with "=_xlfn." which I didn't write.and became;=_xlfn._xlws.FILTERTest1.2!D,Test1.2!C:C=Test1!C7=_xlfn.XLOOKUPTest1!$C$7&Test1!C10,Test1.2!C:C&Test1.2!D,Test1.2!I:I,""=_xlfn._xlws.SORTF2:G38,2,-1I am sure my excel version is up to date as I have checked.

:)

 

Office 2019 Excel Formula

Hi Raymond RJanney,



Thanks for your post in Microsoft Community.



It sounds like you have a concern on Office 2019 Excel Formula. This issue is more appropriate to be posted in IT Pro docs.microsoft.com forums since it's related to the application of Excel formula. You can click Q&A to post your question.



Feel free to post back if you need further assistance.









Best Regards,

Lynn Sun | Microsoft Community Support Specialist

-----------------------

* Beware of scammers posting fake support numbers here.

* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

 

Office 2019 Excel Formula

I've installed Windows10 / Office 2019 several months ago... Question regarding MS Excel... Why doesn't the formula (A) work and my work around formula (B) does? (A) ='Account Analysis 21'!C34:G34... (B) ='Account Analysis 21'!C34+'Account Analysis 21'!D34+'Account Analysis 21'!E34+'Account Analysis 21'!F34+'Account Analysis 21'!G34. Appreciate your feedback.

 

Office 2019

Only supported on Win10. Sorry, 8.1 users, only 4 years old, gotta go.

Microsoft Office 2019 will only work on Windows 10

https://blogs.technet.microsoft.com...-to-office-and-windows-servicing-and-support/

Spoiler Office 2019
Last year at Ignite, we announced Office 2019 – the next perpetual version of Office that includes apps (including Word, Excel, PowerPoint, and Outlook, and Skype for Business) and servers (including Exchange, SharePoint, and Skype for Business). Today we’re pleased to share the following updates:

• Office 2019 will ship in H2 of 2018. Previews of the new apps and servers will start shipping in the second quarter of 2018.
• Office 2019 apps will be supported on:
  • Any supported Windows 10 SAC release
  • Windows 10 Enterprise LTSC 2018
  • The next LTSC release of Windows Server
• The Office 2019 client apps will be released with Click-to-Run installation technology only. We will not provide MSI as a deployment methodology for Office 2019 clients. We will continue to provide MSI for Office Server products.