vlookup or vba

[gloger]

Hi all,
I want to translate every term in my current sheet to another language and I know that I can make a table with term by term correspondence and function vlookup. One thing I don't understand is that I think, may not be right, vlookup is a function and needs to be defined in every cell I want the translation to happen. But, some cells in this sheet are already defined with other functions so vlookup will overwrite the previous function and that is not what I want and so I think of using vba to accomplish that but don't know how exactly..

Thx all in advance!

[daffodil11]

I'd recommend posting an example of your work or creating something similar for us to work with.
VBA has an exacting nature that requires at least some type of foundation for us to code from.

Outside of that, I'd just recommend ample use of Ctrl+H to replace all of 1 term for another a few times.