B
B
baharev2020-08-04 15:59:56
Spreadsheets
baharev, 2020-08-04 15:59:56

How to take part of the formula from another cell?

Tell me how to take part of the formula from another cell, for example:
Full formula:
=IMPORTRANGE("link";"June2020!o2:o2")
the second part is "June2020!o2:o2", I want to take from the cell, you can use the entire text , you can, for example, insert only months in parts, for example, July, and so that the formula works.
I want to pull up the values ​​from different tabs for different months, but at the same time not to edit the formula manually every time.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question