Return a user specified number of cell values to a comma list randomly

[kodarr]

I have variable lists that will have 200–1000 values in them. ex:

1 Reliable
2 Practical
3 Responsible
4 Organized
5 Detail-oriented
6 Logical
7 Hardworking
8 Dedicated
9 Honest
10 Loyal
etc...

The user will be able to put a number in a cell and a different cell will spit out x number of these traits in a comma list. I know how to do this in an if else chain with VLookup if I know how many things I need to return.

However, I can't find any way to do this with the user choosing the number of items since there is no loop function that I can find to repeat the VLookup that many times. If possible I would also like that it never gives the same trait twice but I can live with it if that is not possible.

Is this possible without an if then else repeating the same code over and over for any value the user may put in the number of traits they want?

So if the cell with number of values is B3 and it has a 3 in it. Then the cell displaying the traits which would have the looping vlookup may display "Loyal, Efficient, Patient"

Is there a way to accomplish this? It seems something that should be simple but I can't find anything online about doing something like this.

 

[Eric W]

How about:

david763.xlsx
	A	B	C	D
1	List		Count	Selection
2	Reliable		3	Logical, Honest, Dedicated
3	Practical
4	Responsible
5	Organized
6	Detail-Oriented
7	Logical
8	Hardworking
9	Dedicated
10	Honest
11	Loyal
12
13
Sheet8

Cell Formulas
Range	Formula
D2	D2	=LET(rng,A2:A20,a,COUNTA(rng),s,SEQUENCE(a),b,SORTBY(s,RANDARRAY(a)),TEXTJOIN(", ",1,INDEX(rng,INDEX(b,SEQUENCE(C2)))))