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.


--
disgustipated
------------------------------------------------------------------------
disgustipated's Profile: http://www.excelforum.com/member.php...o&userid=24762
View this thread: http://www.excelforum.com/showthread...hreadid=383304