Forum Discussion

Aleksandr_KirillovUK

Copper Contributor

Apr 16, 2021

I don't have xlookup in my excel

Hi Everyone, I have been using Office 365 and also joined in insider. But unfortunately cant find XLOOKUP function inside

Diamond Contributor

Apr 16, 2021

Aleksandr_KirillovUK

Could you please share your version of Excel from File->About, it looks like

Aleksandr_KirillovUK
Copper Contributor
Apr 16, 2021
Version 2103 (Build 13901.20400 Click-to-Run)
Current Channel (Preview)
- SergeiBaklan
  Diamond Contributor
  Apr 16, 2021
  Aleksandr_KirillovUK
  
  Thank you. Looks strange. Could you please open attached file and check what it shows in formula bar. Inside is nothing but
  
  test XLOOKUP.xlsx10 KB
  - poroa
    Copper Contributor
    Jan 24, 2023
    SergeiBaklan
    The version of my excel is 2016 ( office 2016)