Assigning text values to numeric fields
 

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


--
ab565
------------------------------------------------------------------------
ab565's Profile: http://www.excelforum.com/member.php...o&userid=26199
View this thread: http://www.excelforum.com/showthread...hreadid=395050

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

--
Sincerely, Michael Colvin


"ab565" wrote:


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


--
ab565
------------------------------------------------------------------------
ab565's Profile: http://www.excelforum.com/member.php...o&userid=26199
View this thread: http://www.excelforum.com/showthread...hreadid=395050