Trying to generate a set of randomly selected results from a data set

The intent of my app is to essentially do a vlookup, based on a set of data. I have 15 or so columns of data that hold unique pieces of information per line. I want to be able to have the app randomly display one item from each column in a list. If column A has items 1-10, column B has items 11-20, column C has items 21-30, then for the resulting app, I want to see:

Column A : 7

Column B: 15

Column C: 24

 

Where each column may also have a unique but constant name. The outputs that are random will change each time the app is "rerun" or "refreshed".

0 1 57
1 REPLY 1
Top Labels in this Space