Forum Discussion
Problem Xlookup does not strech down
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.
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.
Thanks
Strange that this is not Checked by default though
In general that's default behaviour, something or somebody eventually changed it.
