Xlookup function not available

Occasional Visitor


I currently use Mac, I have the latest Microsoft 365 but apparently, there's no Xlookup function in my Excel. 

Can someone help me with this?


Screen Shot 2021-07-11 at 10.18.51 pm.png

Screen Shot 2021-07-11 at 10.21.44 pm.png

1 Reply
I‘m Not an Mac Office expert, but it looks like you have Office 2019 and not 365.
XLOOKUP us not aviable in 2019.