Forum Discussion

Janis_K1's avatar
Janis_K1
Copper Contributor
Feb 21, 2023
Solved

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?

 

  • Janis_K1 

    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_K1's avatar
      Janis_K1
      Copper 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? 🤔

      • Janis_K1 

        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.

Resources