Forum Discussion

Copper Contributor

Oct 23, 2021

Can´t find XLOOKUP or PROCX function

Hello, I am trying to use the XLOOKUP or PROCX function in excel fut for some reason I can´t. Can someone help? My excel version is 2109. Thanks.

Diamond Contributor

Oct 23, 2021

It's not available for 2019, only for 2021 and 365 subscribers

miguelfg
Copper Contributor
Oct 23, 2021
SergeiBaklan

I am a 365 subscriber
2109 is the excel version installed.
- mtarler
  Silver Contributor
  Oct 23, 2021
  when you say you can't what does that mean? Are you saying that when you start typing "=x" that you only see XIRR, XNPV, and XOR as function options? When you try to use it what happens? Can you show us a screen shot? maybe you are using the wrong context?
- SergeiBaklan
  Diamond Contributor
  Oct 23, 2021
  miguelfg
  
  I see, I guess it's Current channel. XLOOKUP() shall be available for it, have no other ideas, sorry.

Resources