=TRIM(DEPARTMENT(0)) give you the Department Code or * as a result.

=TRIM(DEPARTMENT("100")) will return the description for department 100

If E6 = 100 and Department 100 description is East Coast then

=TRIM(DEPARTMENT(E6)) will return East Coast