Hello Edward,

How many Categories does the database have? How often are new Categories added?

Read about the =GETNAMEDITEM() function and create a list of the form (in a file or through the define Named items menu choice):

[NamedItems]
ABC=Category Description 1
DEF=Category Description 2

and then use the calculated column =GETNAMEDITEM({Item Category}).