Codes for Text in Excel Worksheet

Hello,

set up a table in your workbook that lists the codes and the text side by side in two separate columns

A   B
10 blue
11 green
15 green

In another area of the spreadsheet, for example in D1 enter the number. In E1 enter this Vlookup formula

=Vlookup(D1,$A$1:$B$3,2,false)

E1 will now contain the text. Copy E1 down and enter more codes in column D.

You can then perform a count of codes in column D to find out how often each code has been used.

This approach can be refined with error trapping to avoid N/A errors in column E if the cell in column D is empty.

cheers,