A
A
arr0w2020-08-23 14:44:50
Google Sheets
arr0w, 2020-08-23 14:44:50

Automatic substitution of values ​​from one table to another?

There is the following table: It is
5f4254c590048915749913.jpeg

necessary that data corresponding to today's date be substituted into the lower table. For example: if today is 08/26/2020, then the value from cell D2 is substituted into cell B9, and the value from cell D3 is substituted into cell B10. Etc.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2020-08-23
@arr0w

=IFERROR(arrayformula(indirect("R2C"&(MATCH(A7;1:1;0))&":R3"&(MATCH(A7;1:1;0)))))

, where A7 is the current date
...R 2 is the first export line
...R 3 is the last export line

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question