Hello
I am working on an excel document and I need to be able to translate between English and French. Because the words don't translate very well on Google, I need to create my own translations list.
Initially I just created two master tabs in my document entitled English and the other French. I just inserted a basic if statement to my working tabs " =IF(A1="English", English!A3,French!A3)". This was a great way to replace all of the headings with either French or English. Now that the document is growing and the tabs are not all the same this is no longer a viable option. I was hoping to find a way to create a list of English and French words and depending on which language is selected, the words would be replaced.
This is my first post ever so please bear with me if this needs more details.
Bookmarks