How to set the random formula of weather conditions with Excel?

= lookup (rand between (1, 4), {1, 2, 3, 4}, {"sunny", "cloudy", "partly cloudy"})

or

=INDEX({ "sunny", "cloudy", "cloudy", "partly cloudy"}, RANDBETWEEN( 1, 4))

or

=CHOOSE(RANDBETWEEN( 1, 4), "sunny", "cloudy", "cloudy", "partly cloudy").