how to change coded departments back to text

[workforce123]

So my issue is that I have a bunch of survey data where the departments and the sites have been assigned a number, 1 = Administration 2 = Finance and so on. I need to turn the numbers into their respective departments and sites however there are alot of departments and site and i don't want to just find and replace every one. Furthermore data is added all the time and i would continue to have to make this transformation over and over again so what I'm wonder is if there is a way to format the department and site columns so the they automatically transform following the table of number's I've created? any ideas here?

[tigeravatar]

workforce123,

Welcome to the forum!
This is a pretty classic use for the VLookup() function.
As a generic example:
=VLOOKUP(Code,Table,2,FALSE)

[workforce123]

yeah I thought about that but you can't do it in the same cell so i'd constantly be preforming this function and creating a new column and copy and pasting the information back in the the correct column.