My company is converting the account codes and I am verifying that each code has been assigned a new one.
I was given 2 tables: 1 with current account codes, and the other provides the new code by range of current account codes. For example, if the current code is 1225, the conversion table would assign a new code K001 for current codes ranging between 1200 and 1299. What function do I use in the current code table, so that the formula assigns the new code to each current code?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!