Answer the question
In order to leave comments, you need to log in
How to make Google Sheets fill in all fields from another sheet depending on the selected value?
I do this
https://docs.google.com/spreadsheets/d/1tT8kbU_Zk5...
Two pages:
1. Sheet 1 - output sheet,
2. Sheet 2 - data sheet.
I try If it is not possible to select an array of all cells in the column, then it gives an error, then it cannot fill the range. autocorrect will occur. =if(A1='Лист2'!A3;'Лист2'!B3;)
tried like this=if(A1={'Лист2'!A3:A5};{'Лист2'!B3:B5};)
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