Answer the question
In order to leave comments, you need to log in
Why do not alphabetic values like OP, IV get into the array, but only numbers using QUERY ()?
Help to understand, please, why only numbers get into the array.
There is a formula:
=index(
QUERY(
SPLIT(
FLATTEN(
{INDIRECT('Массив МВУ'!C3)\INDIRECT('Массив МВУ'!C4)\INDIRECT('Массив МВУ'!C5)\INDIRECT('Массив МВУ'!C6)\INDIRECT('Массив МВУ'!C7)}&"×"&
{INDIRECT('Массив МВУ'!G3)\INDIRECT('Массив МВУ'!G4)\INDIRECT('Массив МВУ'!G5)\INDIRECT('Массив МВУ'!G6)\INDIRECT('Массив МВУ'!G7)}&"×"&
INDIRECT(K9)&"×"&
{INDIRECT('Массив МВУ'!K3)\INDIRECT('Массив МВУ'!K4)\INDIRECT('Массив МВУ'!K5)\INDIRECT('Массив МВУ'!K6)\INDIRECT('Массив МВУ'!K7)})
;"×");
"Select *"
))
=index(
SPLIT(
FLATTEN(
{INDIRECT('Массив МВУ'!C3)\INDIRECT('Массив МВУ'!C4)\INDIRECT('Массив МВУ'!C5)\INDIRECT('Массив МВУ'!C6)\INDIRECT('Массив МВУ'!C7)}&"×"&
{INDIRECT('Массив МВУ'!G3)\INDIRECT('Массив МВУ'!G4)\INDIRECT('Массив МВУ'!G5)\INDIRECT('Массив МВУ'!G6)\INDIRECT('Массив МВУ'!G7)}&"×"&
INDIRECT(K9)&"×"&
{INDIRECT('Массив МВУ'!K3)\INDIRECT('Массив МВУ'!K4)\INDIRECT('Массив МВУ'!K5)\INDIRECT('Массив МВУ'!K6)\INDIRECT('Массив МВУ'!K7)})
;"×"))
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question