Hi,

I have two arrays that correspond with each other. They each contain the same words in different languages. For example, the first array is A2: D5, and the second array is F2:I5.

In one cell, A7 for example, I randomly select a word in the first array, using a combination of INDEX and RAND commands. Once the word is RANDomly selected, I'd like another cell, B7 for example, to return the corresponding word in different language.

In this case, I'd like the word returned in B7 to be an OFFSET of the cell selected by the RAND formula in A7. For example, =OFFSET(???,0,5). That is, if A7 returns the word in C2, I want B7 to return the word in H2. If A7 returns the word in D4, I want B7 to return the word in I4.

Is there a command to refer to the cell which another cell is referring to? I want B7 to refer to the cell A7 is referring to, and then OFFSET that. Any help is appreciated. Thanks.

Clark