If there is a whole group of numbers associating with Consumer,
Commercial etc, you are better off creating a sequence of lists
elsewhere with the numbers pertaining to each classification. In
particular you can put the classifications as headers in a table of
rows with unequal lengths. Say they occupy columns F:H, with F1:H1
containing the headers, i.e. the classifications. Thus 3 different
outcomes.

The following *array* formula will then return the classification:

=INDEX(F1:H1,MIN(ROW(1:3)*IF(COUNTIF(OFFSET(F:F,0, ROW(1:3)-1),A2)=1,1,10)))

*Array Formula* : Needs to be entered with Shift+Ctrl+Enter.

HTH
Kostis Vezerides