jeudi 16 novembre 2017

link between two columns when generating random data

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