You could set up a 2-column table somewhere with the initials in one column and the corresponding word in the other, and then you would be able to use the VLOOKUP function to convert the intiials into the word.
Hope that helps.
Pete
You could set up a 2-column table somewhere with the initials in one column and the corresponding word in the other, and then you would be able to use the VLOOKUP function to convert the intiials into the word.
Hope that helps.
Pete
Could I set it up so that if the cell says X the it will do that?
I don't know what you mean. Post an example workbook (the FAQ describes how to), so it might better illustrate what you are trying to achieve.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks