How do I get Excell 2007 to replace a numeric value with text upon completion of entering the value into a cell?
For instance, I have twelve employees that I know by number. I want to enter the value of say 1 and have Excel 2007 replace that value with the employee's name (Grindstaff) when I hit enter and do the same for all 12 employees. So, when I enter 5 into a cell and press enter I want it to replace 5 with Smithson. When I enter 9 and enter I want 9 to be replaced by Richardson, etc.
Bookmarks