Non repeated use of items in a lookup table?

Is there a way to keep track of which items in the result vector of a lookup table have been used and then prevent them from being used again? Would this have to be done with an array?

Could you give an example of what you are trying to do?

Originally Posted by sara.ridley

Could you give an example of what you are trying to do?

I want to create a flash card game that uses a random lookup value to pull a math problem out of a lookup table but if the problem has already been shown I want it to be eliminated. Is something like this possible? I have worked with an array formula before but can't remember how to do something like this. TIA for any help.

In a column adjacent to the LUT, enter and copy down =RAND(). Sort the table by that column, and use the questions in the order in which they then appear.