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

Question

Google

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.

Answer 1

VLOOKUP will help you, or a bunch of IFs