Soldato
- Joined
- 20 Apr 2004
- Posts
- 4,406
- Location
- Rugby
TDRL: Can I add a search functionally to a sheet translation to more easily see if something has been translated or not ?
I currently have a store text file, eg a excel with element name in one column and a one column per language.
For example
https://imgur.com/a/cNXe6p4
And so on.
Is it possible to create a “search” cell or cells so I can quickly see if one line of text/element has been translated on. EG if I search for “Update” or “yellow” it will search the columns for each language for a result?
I type yellow and if yellow is on the list of translations it will return a result for each region is there isa translation.... Yellow, amarillo, keltainen, geel etc
Would I have to setup a mass of VLOOKUP's or could I use something like the google translate toolkit to help maybe ?
I currently have a store text file, eg a excel with element name in one column and a one column per language.
For example
https://imgur.com/a/cNXe6p4
And so on.
Is it possible to create a “search” cell or cells so I can quickly see if one line of text/element has been translated on. EG if I search for “Update” or “yellow” it will search the columns for each language for a result?
I type yellow and if yellow is on the list of translations it will return a result for each region is there isa translation.... Yellow, amarillo, keltainen, geel etc
Would I have to setup a mass of VLOOKUP's or could I use something like the google translate toolkit to help maybe ?