Excel 2000 Data Labels

[Peter Robertson]

Does anyone know how I can assign data labels to data in a cell. For example
say I had a file of survey data and the data values in the cell stood for:
1=strongly disagree, 2=disagree, 3=neutral, 4=agree and 5=strongly agree, is
it possible in Excel to assign such labels to the data values as can be done
in say SAS or SPSS?

 

[Earl Kiosterud]

Peter,

I think you have the numbers 1 - 5, and want to get the corresponding text.
Make a table:

1 | Strongly disagree
2 | Disagree
3 | Neutral
etc.

Now in the cell where you want the text, use:

=VLOOKUP(A2, ReferenceToTable, 2, FALSE)

A2 is the cell containing the number.

It might look like
=VLOOKUP(A2, J1:K5, 2, FALSE)
if the table is in J1:K5 (which you can hide)