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

[ConanArchives]

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".

[Suvrutt_Gurjar]

Please elaborate on your requirement. In general, based on understanding so far , you could use an expression something like in a VC

INDEX( Table Name[Column Name], RANDBETWEEN(1,10)) to get a random value for each column during each sync.

If you need several columns to be shown together , you could use CONCATENATE() to combine those individual column expressions and add column name etc. such as 

CONCATENATE(

"Column A:  " , INDEX( Table Name[Column A], RANDBETWEEN(1,10)), "

","ColumnB:  " , INDEX( Table Name[Column B], RANDBETWEEN(1,10)), "

","ColumnC:  " , INDEX( Table Name[Column C], RANDBETWEEN(1,10))

)