I have a list of ten names and need to pull one randomly. Is there a way
that I can put a number 1-10 in a cell and it would randomly return one of
the ten names? as an example if I put the number 2 in the cell it would
populate the cell next to it with Name 1. If I cleared it and put a 2 in
again it would populate the cell with Name 6 this time. Or is it possible to
use a button (i.e. spin) to generate the first number and that would populate
the name field?