How to change the value in a formula referring to a cell?

Question

PHP

Good afternoon.
I want to make something like a calculator of goods that are running out and should be purchased.
I have a sheet with parameters

spoiler

In cell E3, I plan to write the name of the month whose sales data I'm interested in.
The data output itself occurs according to the formula

=FILTER('По_месяцам'!A:B;'По_месяцам'!S:S<=E2;'По_месяцам'!H:H>=G2)

Where 'По_месяцам'!H:Hjust denotes a cell with a specific month on another sheet (in this case, MARCH, D - January, F - February).
Is it possible to somehow make these values ​​change depending on the writing of the month in cells E3?

Answer 1

У вас одна таблица для всех страниц? по умолчанию парент = 0?

Answer 2

If the pages are built according to the type of trees - from 0 - the root and further with nesting - for each group, add an additional group id, if the page tree is not more than 100 nodes, then we select all the nodes with the desired group_id, and then using puff we do a search and build chain.

Answer 3

The best option is to make a copy of the table without personal data with edit access.
And so you have to play the battle of psychics
Try 'By_months'! H: H replace with

=ДВССЫЛ("'По_месяцам'!C"&((СТОЛБЕЦ(D1)-2)+2*ПОИСКПОЗ(СТРОЧН($E$3);{"январь"; "февраль"; "март"; "апрель"; "май"; "июнь"; "июль"; "август"; "сентябрь"; "октябрь"; "ноябрь"; "декабрь"};0))&":C"&((СТОЛБЕЦ(D1)-2)+2*ПОИСКПОЗ(СТРОЧН($E$3);{"январь"; "февраль"; "март"; "апрель"; "май"; "июнь"; "июль"; "август"; "сентябрь"; "октябрь"; "ноябрь"; "декабрь"};0));0)