Forum Discussion
Solved
XLOOKUP columns
I am using the latest version of Excel Office 365 on mac. When using xlookup, Excel does not allow me to add a whole column to the formula. Adding cells works just fine. Why is that?
If an error like this
something is wrong with syntaxes. Perhaps you shall use semicolons instead of commas - depends on your regional settings.
Yes, and when clicking on entire column I get the error message.
If an error like this
something is wrong with syntaxes. Perhaps you shall use semicolons instead of commas - depends on your regional settings.
SergeiBaklan Just found out through trial and error that semicolon is the correct input.