I am doing a pool for the show The Bachelor. I need to assign each of my "people" with a "contestant" at random.

I have a sheet with 2 columns of data.

Column A has 28 people in rows 2:29
Column H has 28 contestants in rows 2:29

What formula can I put in Column C to randomly assign a "contestant" from H with no duplicates?