I was browsing for help on this subject and figured someone might be able to help me here.

I have an existing excel spreadsheet that was formed from a larger table in SQL. However in the table there are columns for a colors lens type and the rows in that column only contain numbers which reference another table on the SQL server so that the individual who created it didnt have to type out all of the words and would only place the numbers in the rows. Is there a function I can write or just any other way that I can get all of the rows within that cloumn to change from the number posted to the the word it references in the other table on the server?

Thanks for the help.