L
L
lordycreator2021-07-18 21:05:46
Google Sheets
lordycreator, 2021-07-18 21:05:46

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

1 answer(s)
A
Alexander Ivanov, 2021-07-19
@lordycreator

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...
60f4e051dbea3489406918.gif

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question