Pull random cell on column B if column C is empty

[curb]

I'm pulling a random data from Column B but how would I only pull the ones that has a empty data in Column C?

Here's the code:

=INDEX($B:$B,RANDBETWEEN(1,COUNTA($B:$B)),1)

[Richard Buttrey]

I'm pulling a random data from Column B but how would I only pull the ones that has a empty data in Column C?

Here's the code:

=INDEX($B:$B,RANDBETWEEN(1,COUNTA($B:$B)),1)

Does

=IF(INDEX($C:$C,RANDBETWEEN(1,COUNTA($B:$B)),1)<>"",INDEX($B:$B,RANDBETWEEN(1,COUNTA($B:$B)),1),0)

work? I don't appear to have RandBetween functionality on my Mac.