How can I enter a number and it will fill in a word in the cell

Question

Hi
Can you help, please?
I would like to be able to add a number to a cell in excel say "1" and it will bring up the word "sleeping" any ideas on how to do this, please? I'm&nbsp;new to this!&nbsp;

Before
After&nbsp;

&nbsp;1
&nbsp;

&nbsp;
&nbsp;

sleeping
1

dozing
2

alert and engaged
3

alert and static
4

alert and active
5

alert and irritable
6

alert, distressed and agitated
7

Thanks in advance

sergeibaklan · Answer

With formulas that doesn't work such way, if only with macros. Perhaps it's better to use data validation drop-down list for such case.

haytham amairah · Answer

Hi Niki,
&nbsp;
You can use https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 to do that!
Please find the attached file to see an example of this!

sergeibaklan · Answer

Hi Niki,
&nbsp;
Do you mean you enter the number into the cell down to Before and in the cell down to After it shall appear the text from the table below which corresponds to that number?

niki young · Answer

Yes so I want to enter "1" into cell M3 and it will show "sleeping" instead of the number

Forum Discussion

How can I enter a number and it will fill in a word in the cell

4 Replies

sleeping	1
dozing	2
alert and engaged	3
alert and static	4
alert and active	5
alert and irritable	6
alert, distressed and agitated	7