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:

[TABLE="width: 226"]
<tbody>[TR]
[TD]Winter Motor Company[/TD]
[/TR]
[TR]
[TD]ALL PRO MOTORS[/TD]
[/TR]
[TR]
[TD]AMERICAS AUTO AUCTION[/TD]
[/TR]
[TR]
[TD]Dallas Auto Auction[/TD]
[/TR]
[TR]
[TD]MANHEIM DALLAS FORT WORTH[/TD]
[/TR]
[TR]
[TD]MANHEIM MINNEAPOLIS[/TD]
[/TR]
[TR]
[TD]MANHEIM SAN ANTONIO[/TD]
[/TR]
[TR]
[TD]MANHEIM TEXAS HOBBY[/TD]
[/TR]
[TR]
[TD]METRO AUTO AUCTION[/TD]
[/TR]
[TR]
[TD]SPARKLING CITY AUTO AUCTION[/TD]
[/TR]
</tbody>[/TABLE]

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