Hello

I’m having trouble with the XLOOKUP formula, my excel doesn’t show that it has this formula. I have the newest version of excel and the formula worked perfect on my other computer – windows and now I have Mac Air. I transferred all the files and nothing is working.

The formula

=XLOOKUP(A3;Toiduained!A:A;Toiduained!B:B;)
and shows error #NAME?

How can i get XLOOKUP formula on my excel?

​Hello I’m having trouble with the XLOOKUP formula, my excel doesn’t show that it has this formula. I have the newest version of excel and the formula worked perfect on my other computer – windows and now I have Mac Air. I transferred all the files and nothing is working. The formula=XLOOKUP(A3;Toiduained!A:A;Toiduained!B:B;)and shows error #NAME? How can i get XLOOKUP formula on my excel?    Read More

​