How in Google Sheets to change the text in one cell depending on the number in another?

W

W

witchespoem2022-04-01 13:54:37

Google

witchespoem, 2022-04-01 13:54:37

How in Google Sheets to change the text in one cell depending on the number in another?

Hello, please help!
In one cell there is a drop-down list with numbers, for example 500,501,502 It is
necessary that, depending on the selected number, the text in another cell changes
. All text options are on another sheet.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2022-04-02
@ProgrammerForever

VLOOKUP will help you, or a bunch of IFs

Similar questions

A

asdz2015-12-30 23:08:00

Tormented by some advertising scripts in Chrome, how to remove them? 4Reply

S

Sharapov2016-12-29 13:20:14

Does text indexing get worse with CSS content? 1Reply

P

petriichuk2016-12-29 17:36:26

Is it possible to parse data from a Google Sheet every time a php page is opened? 4Reply

B

BonBon Slick2017-01-04 14:28:02

Google Recaptcha validation - 422 (Unprocessable Entity)? 0Reply

S

Seth262015-01-07 22:17:00

How does google translate voice reading work? Is there a database with the required text, or is there a person sitting on the other side and reading it? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question