SOLVED

# Searching for the right function.

Copper 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?

6 Replies

# Re: Searching for the right function.

That could be like

``=XLOOKUP(D26&F26&G26, D:D&F:F&G:G, H:H)``

# Re: Searching for the right function.

Hi Sergei,
It works!!:thumbs_up::thumbs_up:

But how to "connect" this mechanism with columns: "K;L;M;N" so they would "update/copy" previous inputs too? :thinking_face:

best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Searching for the right function.

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.

# Re: Searching for the right function.

Thanks a lot!
I got it and already "upgraded" a bit for my everyday use. :)

# Re: Searching for the right function.

@Janis_K1 , you are welcome.

As a comment, in general better to use not entire columns like K:K, but some ranges like \$K\$2:\$K\$1000, but all of them shall be of the same size. That's in case of performance issues.

# Re: Searching for the right function.

This was my next question.=))
Thank you!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Searching for the right function.

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.