My table is currently translating phrases in an English catalog to 10 different languages.
My table is set up so that the English phrases go downward and each language is a column across ex. Dutch/German/Spanish/ect.
For example, A2 is Hello, then B2 is "Hola"
ENGLISH SPANISH FRENCH ECT ECT
Hello Hola Bonjour
Goodbye Adios Au reviore
But there may be 15 Hello's down the English column. Instead of tediously copying and pasting Holas and Bonjours in each cell, is there a function that can make Hello become Hola in all instances in Row B ONLY?
It could only apply to one row, because if Row C is French, it would need to say "Bonjour" for all instance of hello.
So I need to make one cell with text equal another cell with text (A1=B1, in all instances of row B only, and so on and so forth
Thank you for your help. Is there any way I can send my sheet as an attachment to help?