Want to set up a translations quiz, using rand between and vlookups, all working fine, except when i go to submit an answer the rand between changes value and makes my answer wrong, have tried a nested if, but circular reference, how can I only get the rand between to change when the answer is correct?
Solved by B. F. in 30 mins