Forum Discussion
Janis_K1
Feb 21, 2023Copper Contributor
Searching for the right function.
Hello!
Please tell me, which function should I use to automatically get data from the previous rows with the same direction?
You may repeat formula in each column, e.g. in K
=XLOOKUP(D26&F26&G26, D:D&F:F&G:G, K:K)
or use in K
=XLOOKUP(D26&F26&G26, D:D&F:F&G:G, K:N)
but cells to the right shall be empty since the latest returns spill.
- Janis_K1Copper Contributor
Hi Sergei,
Wow! Thanks for your super-fast reply!🚀
It works!!👍👍
But how to "connect" this mechanism with columns: "K;L;M;N" so they would "update/copy" previous inputs too? 🤔You may repeat formula in each column, e.g. in K
=XLOOKUP(D26&F26&G26, D:D&F:F&G:G, K:K)
or use in K
=XLOOKUP(D26&F26&G26, D:D&F:F&G:G, K:N)
but cells to the right shall be empty since the latest returns spill.