Answer the question
In order to leave comments, you need to log in
Automatic substitution of values from one table to another?
There is the following table: It is
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
=IFERROR(arrayformula(indirect("R2C"&(MATCH(A7;1:1;0))&":R3"&(MATCH(A7;1:1;0)))))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question