Forum Discussion
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 containing the Lookup Value.
The data to search for is in a second sheet, containg data from a Query (Merge of two CSV's).
The function results in an output, but only in the cell where the function is.
How can I get the out be streched down to all 150 rows containing data?
Without copying it 😉
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.
5 Replies
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 thoughIn general that's default behaviour, something or somebody eventually changed it.
Based on formula function is placed within structured table. Do you mean formula is not auto-expanded on another rows of the table?
- Exactly
