Unable to use the XLookup function in Excel for office 2021

Copper Contributor

Hi I purchased and installed office 2021 for the XLOOKUP function.






It does not come up when I try to type in the function. Office 365 is installed, but the license is under office 2021.

1 Reply


In Excel, select File > Account.

What do you see under Office? This is what I see: