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.
Based on formula function is placed within structured table. Do you mean formula is not auto-expanded on another rows of the table?
Exactly