I have a list of thousands of employees with a security clearance number
between 1 to 20. I now need to substitute that number with a position or
title. Example 5= manager. On each seperate work sheet I am substituting of
one number at a time (all 5's to managers). However, it needs to be done
1-20 on each sheet. With a seperate worksheet for every department
(hundreds), it will take a week. Is there a way it can be formulated? How
do I associate/substitute a number with a text and back again?