My excel does not recognize the Xmatch function

Question

,Hello

I'm working in a company with a few other employs , one of them built an excel sheet using Xmatch function. when i try to use the file i get alot of #NAME error due to the xmatch function.

I checked and my excel does not recognize the Xmatch function and does not offer it when i write down function of my own.

i did an update for excel in hope that this will fix the problem but for no use.

I have excel from 2019, and now it up to date. 

is there any reason why i cant use the X functions, and more importantly- is there a way to add them to my computer.

Thank in advance,

Niv.

Answer 1

,Hello

I'm working in a company with a few other employs , one of them built an excel sheet using Xmatch function. when i try to use the file i get alot of #NAME error due to the xmatch function.

I checked and my excel does not recognize the Xmatch function and does not offer it when i write down function of my own.

i did an update for excel in hope that this will fix the problem but for no use.

I have excel from 2019, and now it up to date. 

is there any reason why i cant use the X functions, and more importantly- is there a way to add them to my computer.

Thank in advance,

Niv.

.XMATCH works only in EXCEL 365 & EXCEL FOR THE WEB

There is no option to add it to your (2019) versionPls pls take a look at:  XMATCH

PS This is a Hebrew Disscussion Group.  Pls use "our" language in your future posts.Txs