I am working with Excel 2007.

In my spread sheet I have:

l A l 001 l
------l 002 l
------l 003 l

This means "A" is equal to "001", "002", or "003". It does not matter which.

I want that whenever I type "A" into a cell, that "A" is changed to either "001", "002", or "003". I want it to change randomly between the three options so that"A" is not always "002", or whichever.

I want the formula to say: IF "A", then randomly change to "001", "002", or "003".