Use a variable as a cell address

[Tarfon]

This must be kindergarten level Excel, but I can't do it!
How do I use a variable as a cell address?
I want to practice French words at random from a vocabulary list comprising two columns: A containing English words and B containing the equivalent French words.
I want to generate a random number in a cell and the use this to prompt me with an English word at random. I want to enter my guess at the French word which if correct will register TRUE or, if wrong, FALSE and present me with the correct answer. When I press ENTER, I want to be presented with the next English word at random.
1. At this stage, the TRUE and FALSE business looks pretty simple but my first problem is using the Random number to call an English word string from the cell Ax where x is the random number. What function do I use?
2. The next problem may be initiating the generation of the next random number, hopefully just by using the ENTER key.
Can anybody please advise?
Cheers,
Tarfon

[BlastRanger]

Hey,
This is interesting.
Try see my attachment whether that fit your criteria or not.

Cheers

NOTE :
Change Value only the Yellow Cell.
The Hold Question must have value to hold the question (regardless of any value it is), if it is blank, the English always change.
Before you start to evaluate, if you got error message appear that tells you about Circular References, then you go to Excel Option, Formula, Enable Iteration set to Max of 1 (check it first)

[BlastRanger]

Sorry,
here is another version that include the Correct answer if the answered is wrong

[Tarfon]

Many thanks. I think you've put me on the right track, now. I just have to get my head around the actual logic of the nested IFS and the INDIRECT function.
Your first solution works fine, but your second one seems to be always telling me I've the wrong answer because I think it is comparing my entered French answer to the next English prompt.
I'll keep working on it.
It is interesting, though, isn't it.

[BlastRanger]

Yeah thats interesting function.
I wonder why you always get telling about the wrong answer.
It works for me, the correct answer always showup ONLY when the answered french is wrong

Please NOTE :
You have to hold the question by entering value in the HOLD cell