Excel 2000 Data Labels

P

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?
 
E

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top