F
F
feniksdv2019-06-23 12:18:52
Google Sheets
feniksdv, 2019-06-23 12:18:52

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

1 answer(s)
F
feniksdv, 2019-06-23
@feniksdv

I was able to solve it myself with this formula
=INDEX('Лист2'!B1:B3;MATCH(A8;'Лист2'!A1:A3;0))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question