Conceptually, this could work with a formula like this:
=IF(E2=INDEX(B2:B4,MATCH(D2,A2:A4,0)),"CORRECT", "Incorrect, "&D2&" means "&INDEX(B2:B4,MATCH(D2,A2:A4,0)))
However, you've got an inherent problem in your worksheet that will prevent this from working:
When you enter your answer, excel will have to calculate the spreadsheet in order to tell you if your answer is right.
But, at the same time, it will also re-run the calculation of the randomly selected verb.
Which means that even if your answer was right, it won't be right anymore after Excel recalculates...
See attached for a rough demo.
The problem is in the way that Randbetween() automatically recalculates each time the spreadsheet updates...
Bookmarks