coding a list

[Guest]

Hi.

I have a survey that I have to enter on excel, and I wanted to know if there was a way to code the choices (ie: 1=health center, 2=hospital, 3=health department, etc). I've done this before, but I just can't seem to remember how! Please let me know if you can help.

Thanks,
Angela

 

[Bernie Deitrick]

Angela,

You can make up a list like this, in cells A1:B3

1 health center
2 hospital
3 health department

Then when you enter a 1, say in cell D1, you can use a formula in E1:

=VLOOKUP(D1,$A$1:$B$3,2,FALSE)

to convert the number to the words.

HTH,
Bernie
MS Excel MVP

Hi.

I have a survey that I have to enter on excel, and I wanted to know if

there was a way to code the choices (ie: 1=health center, 2=hospital,
3=health department, etc). I've done this before, but I just can't seem to
remember how! Please let me know if you can help.