I'm sorry if this is already here somewhere, but I could't find any references.

I need to upload a list of people into our computer system and this list is
comprised of their names and the code for the branch where they work. The
computer system into which I need to upload this list will not recognize the
current branch ID code for those employees, but I do have a list that is
basically a comparison of the two different codes. For example branch code
800 on the list equals branch code C001 in the system. I need to get a way in
excel to convert all the branch codes that are next to the employees to the
code I have currently in our system. Is there a way in Excel to "translate"
the existing (non-system recognized) codes into the ones that they euate to
in the system? I'm sorry if this is a basic question. I only starte using
Excel a little while ago and am learning as I'm going.

Thanks