Assigning text values to numeric fields

A

ab565

How do I assign a text value to a numeric field? For example, If the
pre-determined value in a field is 1, I want it to automatically update
to "Marketing". Thanks
 
M

Michael

If you have a set number of numeric values, you could create a separate table
of those, for example, in A1 thru B4:

ID No. Department
1 Marketing
2 Accounting
3 Sales

You could then use VLOOKUP: If your numeric item is in C2, the formula
would be
=VLOOKUP(C2,A$1$:B$4$,2,False). I find it best to have the data table on a
separate sheet. Use the VLOOKUP function from the formula bar (Excel 2003).
HTH
 
Top