Sorry VLOOKUP should be entered in D1 and copied to D20
=VLookup (C1,A:B,2,False)

assuming you have entered the RAND() formula in C1 and your Serial Numbers
are in Col A and Names in Col B...

"ziggi456" wrote:

Hi
I have a list of people (approx 200) and need daily to pick 20% of these
people on a random search