Answer the question
In order to leave comments, you need to log in
How to display the corresponding text in the adjacent cell when selecting a value from the drop-down list?
Hey! You need to make a drop-down list of values, and when you select one or another value in an adjacent cell, display the text corresponding to this value from another sheet.
Conditionally: we select “Hello!” in the list, “Hello!” is automatically displayed in the adjacent cell, because the Hello value is assigned to Hello on another sheet. I hope I explain clearly.
Roughly speaking, this should turn out to be a kind of "question-answer", where I select a question in the list, and I get the answer in the cell (ready-made answer on the next sheet).
Thanks in advance!
It would be cool if they gave a specific ready-made formula based on what is indicated above (:
Answer the question
In order to leave comments, you need to log in
This is what the formula does. VLOOKUP
=INDEX(IFERROR(VLOOKUP(A:A;'Данные'!A:B;2;)))
Example in Spreadsheet https://docs.google.com/spreadsheets/d/1pV_uC-CORb...
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question