Assign a random name to 1000 vehicles

[kumar1803]

Hello,


I have a list of 1000 vehicles with VIN numbers in column A.

I would like to assign each VIN a random name from the following names available:

Winter Motor Company

ALL PRO MOTORS

AMERICAS AUTO AUCTION

Dallas Auto Auction

MANHEIM DALLAS FORT WORTH

MANHEIM MINNEAPOLIS

MANHEIM SAN ANTONIO

MANHEIM TEXAS HOBBY

METRO AUTO AUCTION

SPARKLING CITY AUTO AUCTION

<tbody>
</tbody>

Please let me know how can i randomly assign a name to 1000 vin above.

thank you

 

[mikerickson]

If the VINs are in column A and the names in column N, you could put

=INDEX(N:N,RANDBETWEEN(1,COUNTA(N:N)),1)

in B1 and drag down to B1000