I have a spreadsheet of words in German and English.
For example:
A B C D
1 Hallo Hello random word
2 Blau Blue
3 Hund Dog
4 Blumen Flowers
5 Auto Car
And in a random cell (say in cell D1) I can generate a random german
word from column A using:
=INDEX($A:$A|RANDBETWEEN(1|COUNTA($A:$A))|1)
Now in E1, I want to print the appropriate english
word. So when we press F9
and generate a new random word, I always get the correction translation.
Any suggestions on how to make this link?
Aucun commentaire:
Enregistrer un commentaire