How do I associate text with a number?
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? |
How do I associate text with a number?
a security clearance number between 1 to 20.
Create a 2 column table with the number in the left column and the corresponding title in the right column: ...........A..........B 1........1.......title1 2........2.......title2 3........3.......title3 4........4.......title4 5........5.......title5 20....20.......title20 Then, assume D1 contains the security clearance number: D1 = 4 Use this formula to get the corresponding title: =INDEX(B$1:B$20,D1) -- Biff Microsoft Excel MVP "JJA" wrote in message ... 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? |
All times are GMT +1. The time now is 07:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com