Forum Discussion

miguelfg's avatar
miguelfg
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.
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 23, 2021

miguelfg 

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

miguelfg's avatar
miguelfg
Copper Contributor
Oct 23, 2021

SergeiBaklan 

 

I am a 365 subscriber

2109 is the excel version installed.

  • mtarler's avatar
    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's avatar
    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