Forum Discussion
Solved
Problem Xlookup does not strech down
Hi There I am trying to combine some data using the Xlookup function =XLOOKUP([@Projectnummer];Samenvoegen_Import[serial nr];Samenvoegen_Import[name]) The function is in the sheet conta...
Did you enter the formula in a column of the same table that contains Projectnummer?
If so, the formula should be propagated to all rows of the table if you have the following setting:
Select File > Options.
Select Proofing in the navigation pane on the left.
Click the AutoCorrect Options... button.
Activate the AutoFormat As You Type tab.
Make sure that the check box Fill formulas in tables to create calculated columns is ticked.
That did the trick 😉
Thanks
Strange that this is not Checked by default though
Thanks
Strange that this is not Checked by default though
In general that's default behaviour, something or somebody eventually changed it.