2. Then open the Insert Function dialog box and select all in the category.
3. Then find RANDBETWEEN and click.
4. Then set the lowest and highest values of numbers.
5. Then enter = vlookup (d2, a2: b 1 1, 2, false) in the random person box.
6. Finally, you can see the spot check number and the corresponding spot check personnel.