Need a formula to pick a random value from a list of values

[csh8428]

I have to dummy up some data for a bunch of fields. Each field has a list of valid values. I've seen workflows on how to do this for one field using unique ids and such, but that's too much to multiply for every field. I'm looking for a formula that I can use. Is there a function that says "pick a value from this list of strings"?

For example, let's say I have 2 columns: [Car] and [Color]. The values to pick from are such: [Car]: Ferrari, McLaren, Lambo. [Color]: Red, White, Yellow

For every  record I want to randomly generate the value for each column with the corresponding list of values.

Thanks for any help!

Craig

[Amol_Telore]

@csh8428 here is one more way of doing this, using formulas.

[Raj]

@csh8428 Please let us know if you have achieved your required result or let us know if there is something else you were looking for.