Excel 2000 Data Labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Robertson - 30 Jun 2005 02:24 GMT

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?

Reply to this Message

Earl Kiosterud - 30 Jun 2005 02:31 GMT

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)

Signature

Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

> Does anyone know how I can assign data labels to data in a cell. For
> example
[quoted text clipped - 4 lines]
> done
> in say SAS or SPSS?

Reply to this Message